How do I define X-axis stepping?

  • Thread starter Thread starter ChrisCasey
  • Start date Start date
C

ChrisCasey

Hi,

I would like to chart some data. For illustrative purposes, let's sa
that it looks like this:


Code
-------------------
MONEY DONORS
(X) (Y)
$1000 5
$50 7
$1 2
-------------------


I would like to make an Area Graph of the data. However, when I d
this, the X axis is divided into three even parts, one for $1000, on
for $50, and one for $1 -- that is to say, the gap between $1 and $5
is the same size as the gap between $50 and $1000. I would instea
like to see the width of the graph dedicated to the full range o
possible values, $1 to $1000, with the midpoint being $500 (and thu
the datapoint for $50 very near to the one for $1, on the right).

Can this be done easily in Excel, or should I find a separate chartin
package?

(In actuality, I have about 100 X-values in the range of 500 to 4000)

Thanks for any help,
Chri
 
Select the chart, then select Chart | Chart Options... | Axes tab. In
there, set the Category (X) axis to 'Time scale.'

Subsequently, you may have to adjust the format of the x-axis and set the
Number format by hand (double-click the x-axis, then click the Number tab).

That said, I am not sure an Area Chart is the ideal way to represent this
data set. You may want to look at a Column chart (or even a Bar chart).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top