Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Axis labels problem when referenced workbook not open... | Charts and Charting in Excel | |||
Have a chart line completely disappear for a Series... | Excel Worksheet Functions | |||
EXCEL 2003 - LINES DRAWN ON CHART DISAPPEAR - WILL NOT STAY VISABL | Excel Discussion (Misc queries) | |||
10 000 Line, every 2 Lines need a border and a open line inbet. e. | Excel Discussion (Misc queries) | |||
Pie chart data labels and lines disappear | Charts and Charting in Excel |