Hi,

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


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


I would like to make an Area Graph of the data. However, when I do
this, the X axis is divided into three even parts, one for $1000, one
for $50, and one for $1 -- that is to say, the gap between $1 and $50
is the same size as the gap between $50 and $1000. I would instead
like to see the width of the graph dedicated to the full range of
possible values, $1 to $1000, with the midpoint being $500 (and thus
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 charting
package?

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

Thanks for any help,
Chris


--
ChrisCasey
------------------------------------------------------------------------
ChrisCasey's Profile: http://www.excelforum.com/member.php...o&userid=36609
View this thread: http://www.excelforum.com/showthread...hreadid=563532

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

In article ,
says...

Hi,

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


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


I would like to make an Area Graph of the data. However, when I do
this, the X axis is divided into three even parts, one for $1000, one
for $50, and one for $1 -- that is to say, the gap between $1 and $50
is the same size as the gap between $50 and $1000. I would instead
like to see the width of the graph dedicated to the full range of
possible values, $1 to $1000, with the midpoint being $500 (and thus
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 charting
package?

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

Thanks for any help,
Chris


--
ChrisCasey
------------------------------------------------------------------------
ChrisCasey's Profile: http://www.excelforum.com/member.php...o&userid=36609
View this thread: http://www.excelforum.com/showthread...hreadid=563532