Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
$values on y axis % change on x axis
I would like to chart a $ value on the y axis and show the % increase (not in
$s) along the x axis. The values along the y axis would range from $200 to 400 with x axis running from 10%, 12%,7%,11%,9%, showing the change over a 5 year period. Thanks -- al |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
$values on y axis % change on x axis
Hi,
You could plot the data on a xy-scatter. Format the x axis as percentage and Y axis as Currency. Cheers Andy al wrote: I would like to chart a $ value on the y axis and show the % increase (not in $s) along the x axis. The values along the y axis would range from $200 to 400 with x axis running from 10%, 12%,7%,11%,9%, showing the change over a 5 year period. Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
$values on y axis % change on x axis
thank you.
Al -- al "Andy Pope" wrote: Hi, You could plot the data on a xy-scatter. Format the x axis as percentage and Y axis as Currency. Cheers Andy al wrote: I would like to chart a $ value on the y axis and show the % increase (not in $s) along the x axis. The values along the y axis would range from $200 to 400 with x axis running from 10%, 12%,7%,11%,9%, showing the change over a 5 year period. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
How do you change the values of a graph on the x-axis? | New Users to Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
How do I change X-Axis values in a chart with 2 Y-Axis? | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel |