charting vast dispursed data

January 7, 2011 at 13:52:09
Specs: Windows XP
I want to create a chart, my data contains numbers from 1000-1200 and data at 20-25. I want to use a line chart because this data needs to be shown over the whole month. if i chart 1000 and then the next day 25, the 25 looks like 0. should i format my axis specially? or what?

See More: charting vast dispursed data

Report •

#1
January 10, 2011 at 15:36:42
Have you tried to Format the Y axis as a Logarithmic scale?

You can choose whatever base number give you a chart that you can live with.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 11, 2011 at 15:42:03
okay, i understand I can start at 500, but can I go from 500 to 900 then 910 920 930 940 950 960 970?

Report •

#3
January 11, 2011 at 18:43:59
Your first post used numbers like 20 - 25 and 1000 - 1200.

Now you're asking about 500 and 900 - 970.

Make up our minds. What does your data actually look like?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
January 12, 2011 at 09:13:56

Mon Tues Wed
A. 402 1,388 1,025
B. 362 1,283 970
C. 8 41 35
D. 32 64 20


This is the actual data, how do I chart line D with line A


Report •

#5
January 12, 2011 at 09:15:34

Mon Tues Wed
A. 402 1,388 1,025
B. 362 1,283 970
C. 8 41 35
D. 32 64 20

This is the actual data, how do I chart line D with line A


Report •

#6
January 12, 2011 at 11:17:13
What version of Excel are you using?

I am assuming that Mon, Tues, Wed are your 3 series and that your Y values range from 8 to 1,388.

If that's correct, then create a line chart, right-click the Y axis and choose Format Axis.

In Excel 2003, choose the Scale tab and click the box next to Logarithmic scale.

In 2007/2010, you can choose Logarithmic scale and then choose a "Base" value to change the scale of the Y axis.

This will give you more "room" for your lower values so they don't hover around the X axis (near zero).

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question