Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
shift Y axis | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel |