View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default $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