Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y axis fixed value problem
Hi,
I'm working with fairly large datasets, ~10k lines in 6-10 columns. The data are elevations taken on the hour, every hour for a year or two. When I graph these in 2007, I use a connected scatter plot, just as I would in 2003. Excel happily works with the data and creates the graph, but doesn't always get the vertical axis scaling how I want it. As soon as I try to fix the values for this axis where I need them, the program slows to a crawl. Spreadsheet functions still work fine, but anything involving the chart is slow. For example, a right click on the series in the chart will take at least 10 minutes to register, if it does at all. In the meantime, Excel freezes completely. I've tried to recreate the problem with smaller data sets, but it doesn't seem to do anything wrong. Is this a problem with my data set or with excel? Thanks -Tom |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y axis fixed value problem
This is precisely the problem (lots of data, non-automatic axis scale) that
a recent hotfix is supposed to address. I've found it changes the behavior from excruciatingly slow to merely very slow (not as fast as 2003). The information is located at http://support.microsoft.com/kb/938538 Contact MS and they'll send you an email with a download link. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "tom r" wrote in message ... Hi, I'm working with fairly large datasets, ~10k lines in 6-10 columns. The data are elevations taken on the hour, every hour for a year or two. When I graph these in 2007, I use a connected scatter plot, just as I would in 2003. Excel happily works with the data and creates the graph, but doesn't always get the vertical axis scaling how I want it. As soon as I try to fix the values for this axis where I need them, the program slows to a crawl. Spreadsheet functions still work fine, but anything involving the chart is slow. For example, a right click on the series in the chart will take at least 10 minutes to register, if it does at all. In the meantime, Excel freezes completely. I've tried to recreate the problem with smaller data sets, but it doesn't seem to do anything wrong. Is this a problem with my data set or with excel? Thanks -Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem Importing Fixed Width Data | New Users to Excel | |||
How do I keep fixed and Non-fixed decimals on a sheet together? | Excel Worksheet Functions | |||
drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
Problem with draging a formula,one cell value fixed,trivial question | Excel Discussion (Misc queries) | |||
FIXED formula problem | Excel Worksheet Functions |