#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 55
Default Graphs dissapear

Using XL2003. I'm posting here instead of excel.crashesgpfs because
technically this isn't a crash, but still-

I have a worksheet with about 2000 rows of data, maybe 20 columns. Most are
static, but a few columns have formulas. I split the data into three groups,
then am trying to graph each of the three so I can see the variation.

Process:

1. Select a single column range of about 500 cells, use chart wizard to
graph it
2. make a copy/paste of the graph, resize it a little, then change the Y
Axis from -400/+400 to -100/+100 to get rid of the outliers on this second
chart and show the majority of the data in a way that the variation is
easier to see
3. Make a copy/paste of the first chart, and resize it

here's where it gets weird-

4. change the source data of this last chart to the second column of data-
just changing the column from M to N, and the rows from 7-500 to 501-1500-
so I'll have a graph that looks the same with just a different data range

Now all three graphs dissapear from my worksheet!

Any idea what is causing this, and how to get around it?
Thanks,
Keith


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
cells in excel dissapear javier ronquillo Excel Discussion (Misc queries) 1 October 11th 06 01:05 AM
Are there better GRAPHS within EXCEL or Add-on graphs? Deb Charts and Charting in Excel 1 February 1st 06 01:19 PM
Automatic Graphs/ Dynamic Graphs DanielWalters6 Charts and Charting in Excel 1 January 24th 06 09:29 PM
New menu will eventually dissapear in Excel Nash Excel Discussion (Misc queries) 1 November 18th 05 06:00 PM
Copy with link between sheets - all the formats dissapear?!? Kathrine Excel Discussion (Misc queries) 1 February 4th 05 03:45 PM


All times are GMT +1. The time now is 12:38 AM.

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"