$values on y axis % change on x axis

A

al

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
 
A

Andy Pope

Hi,

You could plot the data on a xy-scatter.
Format the x axis as percentage and Y axis as Currency.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Scatter chart with categories on x-Axis 2
Use text descriptors as Y axis units 1
Gantt chart duration not showing 0
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Excel 2007: X-axis labeling 1
Adding a line to a population bar chart 0
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1

Top