Graph does not display properly

**ravichander** · 01-29-2009, 02:21 PM

Hi all:

I have a graph that does not display properly. I have attached a screen shot of that graph for you to see. What should I do to avoid this issue? Thanks.

- Ravi

**shg** · 01-29-2009, 02:31 PM

??

Change the major units on the Y axis?

You have a better chance of getting useful help if you post workbooks instead of pictures.

**ravichander** · 01-29-2009, 03:11 PM

Hi shg:

Thank you fro your response. I have attached a copy of that particular worksheet as you suggested. Thanks.

- Ravi

**ravichander** · 01-30-2009, 01:54 PM

SHG:

Under Axis Options, I have the following:

Minimum = Auto
Maximum = Auto
Major Unit = Fixed 10000.0
Minor Unit = Fixed 2000.0
Horizontal Axis = Automatic

What should I change the Major Unit in the "y" axis to? Thanks.

- Ravi

**Andy Pope** · 01-31-2009, 09:41 AM

It's hard to tell from your file as there are series referencing a workbook local to your PC.

You need to adjust the X axis (horizontal) as it contains values between 0 and 300,000
If you format the X axis to have Auto Major Unit you will get a clearer labelling of the axis.

**ravichander** · 01-31-2009, 02:26 PM

Hi Andy:

Thank you for your response.

As you indicated, I played around with the Format Axis option for both the x and y axis and it worked out well.

Thank you very much for your suggestion. SHG had mentioned this, but I am not familiar with graphs.

- Ravi