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