Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default XL2007: line chart lines disappear when referenced workbook is not open


What we are doing is putting the charts in a separate workbook to the
data that they are drawn from.

This works fine in Excel 2003. But in Excel 2007 and Excel 2010 it is
really weird.

Can someone please confirm this.

1. Open a new workbook.
2. On Sheet1:make a range of data
3. On Sheet2:create a chart with "lines and dots" chart type that
displays the data from "Sheet 1"
4. Save the workbook.
5. Copy the Sheet2 to a new workbook.

Notice that in the new workbook there are lines connecting the dots on
the chart.

Now close the first workbook with the data. Notice that on the second
workbook the lines have gone but the dots still show up where they
should.

Now open the first workbook with the data. Notice that on the second
workbook the lines are back.

Now close the first workbook with the data. Notice that on the second
workbook the lines have gone but the dots still show up where they
should.

If the dots don't disappear then why do the lines?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 31
Default XL2007: line chart lines disappear when referenced workbook isnot open

On Jul 11, 11:57*pm, Jerry wrote:
What we are doing is putting the charts in a separate workbook to the
data that they are drawn from.

This works fine in Excel 2003. *But in Excel 2007 and Excel 2010 it is
really weird.

Can someone please confirm this.

1. Open a new workbook.
2. On Sheet1:make a range of data
3. On Sheet2:create a chart with "lines and dots" chart type that
displays the data from "Sheet 1"
4. Save the workbook.
5. Copy the Sheet2 to a new workbook.

Notice that in the new workbook there are lines connecting the dots on
the chart.

Now close the first workbook with the data. *Notice that on the second
workbook the lines have gone but the dots still show up where they
should.

Now open the first workbook with the data. *Notice that on the second
workbook the lines are back.

Now close the first workbook with the data. *Notice that on the second
workbook the lines have gone but the dots still show up where they
should.

If the dots don't disappear then why do the lines?


Microsoft totally reworked how charting works in 2007. Some good,
some bad features. Sounds like you found one of the bad one.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Axis labels problem when referenced workbook not open... InquiringMind Charts and Charting in Excel 1 October 20th 09 03:34 PM
Have a chart line completely disappear for a Series... Setts Excel Worksheet Functions 1 June 21st 08 06:45 AM
EXCEL 2003 - LINES DRAWN ON CHART DISAPPEAR - WILL NOT STAY VISABL SCPU173 Excel Discussion (Misc queries) 0 March 15th 06 05:31 AM
10 000 Line, every 2 Lines need a border and a open line inbet. e. annalie Excel Discussion (Misc queries) 2 January 30th 06 04:15 PM
Pie chart data labels and lines disappear Sally Sibthorpe Charts and Charting in Excel 0 July 15th 05 03:47 PM


All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"