Re: Modifing data to show up better in chart.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tushar Mehta <tmUnderscore200310@xxxxxxxxxxxxxxxxxxxx>
Date: Thu, 18 Aug 2005 15:52:13 -0400

In article <A9E6F75B-7307-4291-BC7D-729F9DF88D50@xxxxxxxxxxxxx>,
MikePunko@xxxxxxxxxxxxxxxxxxxxxxxxx says...
> My Y1 axis is from 0-250 my Y2 axis is from 0-9000
> When graphing percentages the line shows up at the very bottom since 99% < 1
> is there a way I can multiply these percentages by 100 to show them as 9900%
> = 99
>
> Normally you would just make then a 2nd axis but as you can see I already
> have a second axis of 0-9000
>
In some empty column add a formula =100*{original data} and plot this
new column. Though, I suspect you will have to use a multiplier
significantly larger than 100 if that series is on the Y2 axis. ;-)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
.

Follow-Ups:
- Re: Modifing data to show up better in chart.
  - From: Mike Punko
- Re: Modifing data to show up better in chart.
  - From: Dan

References:
- Modifing data to show up better in chart.
  - From: Mike Punko

Prev by Date: adding space between columns in a chart
Next by Date: Re: How can I export an excel 2003 chart to a .jpg?
Previous by thread: Modifing data to show up better in chart.
Next by thread: Re: Modifing data to show up better in chart.
Index(es):
- Date
- Thread