Graphs dissapear

K

Keith R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Unreadable text when viewing organization chart in Web version of Visio 365 0
Automatic Macro to create 200 graphs 1
Plotting Line Graphs to Specific Bar Graphs 0
Dynamic graph 0
Creating Network Diagram using a Chart SW integration 0
Combining a 2-D column graph and a 2-D line graph on the same char 3
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0

Top