If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart x-axis and name problem
I have a quite complex workbook in Excel 2007 with several charts, including
a xy scatter chart with 3 series. The number of points plotted has been gradually increasing, and when it exceeded 185 on each series, the x-axis (which is set to Auto for the minimum) suddenly switched to displaying 0 as the minimum point, thus pushing the plotted area to the right of the chart. I verified that if I exclude either the first or last point on the series, the display is OK. At the same time, all charts sheets lost their names, and became chart1, chart2, chart3. Renaming them appeared to work, but on saving and reopening the wrokbook this problem reappeared. I have now set the minimum manually to the lowest value, which resolves the first problem; after restarting Excel, the second problem now seems to have gone away. However all this looks like a bug, as the specificaions indicate that a data series can contain up to 32,000 points. Any ideas? -- Andrew B |
#2
|
|||
|
|||
Chart x-axis and name problem
I would be interested in seeing a sample file
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Andrew B" wrote in message ... I have a quite complex workbook in Excel 2007 with several charts, including a xy scatter chart with 3 series. The number of points plotted has been gradually increasing, and when it exceeded 185 on each series, the x-axis (which is set to Auto for the minimum) suddenly switched to displaying 0 as the minimum point, thus pushing the plotted area to the right of the chart. I verified that if I exclude either the first or last point on the series, the display is OK. At the same time, all charts sheets lost their names, and became chart1, chart2, chart3. Renaming them appeared to work, but on saving and reopening the wrokbook this problem reappeared. I have now set the minimum manually to the lowest value, which resolves the first problem; after restarting Excel, the second problem now seems to have gone away. However all this looks like a bug, as the specificaions indicate that a data series can contain up to 32,000 points. Any ideas? -- Andrew B |
Thread Tools | |
Display Modes | |
|
|