Re: Modifing data to show up better in chart.

What article number?

--
Regards,

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

In article <6D0BF7F2-5751-4454-8844-A90CDEF6852D@xxxxxxxxxxxxx>,
Dan@xxxxxxxxxxxxxxxxxxxxxxxxx says...
> How do I use the article number you referenced in your reply.
>
> "Tushar Mehta" wrote:
>
> > 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
> >
>
.

Relevant Pages