$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 |
$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 |
$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 |
All times are GMT +1. The time now is 07:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com