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?

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.

okay, i understand I can start at 500, but can I go from 500 to 900 then 910 920 930 940 950 960 970?

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.

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

Mon Tues Wed

A. 402 1,388 1,025

B. 362 1,283 970

C. 8 41 35

D. 32 64 20This is the actual data, how do I chart line D with line A

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.

Ask Your Question

Weekly Poll