| 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 | |||
Hybrid Mode
