Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Problems changing x-axis with large data sets
I have relatively large data sets (for example 8 sets of 1500 x/y-values)
that I want to plot in one chart. So far all is fine. But if I want to change the x-axis scale (to show the curves better, for example from 0-100 to 20-40), everything becomes very slow. Just to mark one curve or try to move the chart within the sheet can take one minute! If I do the same i Excel 2003, there is no delay or problem. Is there a simple solution, or do I have to stick with old Excel? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Problems changing x-axis with large data sets
Excel 2007 is a notoriously poor charting performer, particularly if you
customize the scale of an axis. Excel 2007 SP1 somewhat improves on this poor performance. Excel 2003 will always outperform 2007. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Helena" wrote in message ... I have relatively large data sets (for example 8 sets of 1500 x/y-values) that I want to plot in one chart. So far all is fine. But if I want to change the x-axis scale (to show the curves better, for example from 0-100 to 20-40), everything becomes very slow. Just to mark one curve or try to move the chart within the sheet can take one minute! If I do the same i Excel 2003, there is no delay or problem. Is there a simple solution, or do I have to stick with old Excel? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Problems changing x-axis with large data sets
Thank you for your response. I installed SP1 and it seems to be better now.
/Helena "Jon Peltier" wrote: Excel 2007 is a notoriously poor charting performer, particularly if you customize the scale of an axis. Excel 2007 SP1 somewhat improves on this poor performance. Excel 2003 will always outperform 2007. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Helena" wrote in message ... I have relatively large data sets (for example 8 sets of 1500 x/y-values) that I want to plot in one chart. So far all is fine. But if I want to change the x-axis scale (to show the curves better, for example from 0-100 to 20-40), everything becomes very slow. Just to mark one curve or try to move the chart within the sheet can take one minute! If I do the same i Excel 2003, there is no delay or problem. Is there a simple solution, or do I have to stick with old Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
manipulating large data sets for graphing | Excel Discussion (Misc queries) | |||
VLOOKUP in large Data sets of more than 16384 rows | Excel Worksheet Functions | |||
how to save large data sets in excel | Excel Discussion (Misc queries) | |||
Excel graphs - two data sets on the same y-axis? | Excel Discussion (Misc queries) | |||
Need to display 4 sets of data on one x-axis with 4 repeating y a. | Charts and Charting in Excel |