View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paula Paula is offline
external usenet poster
 
Posts: 138
Default Chart with 2 Axis

Hi, I have a chart which I am struggling with, I can usually do dual axis
charts but this wont let me. Below is the data I am trying to plot. I would
like the first 2 sets of values in a bar and the last in a line, however
when I plot the first set of data is so high value that I cannot locate the
second and 3rd data series to plot onto a secondary axis. Any ideas of how I
could resolve?

Many thanks
Paula


Jan-08 2585637 3485 741.933142
Feb-08 2600656 3255 798.9726575
Mar-08 2550071 2725 935.8058716
Apr-08 5316538 5181 1026.160587
May-08 10148492 9629 1053.950774
Jun-08 9863458 9482 1040.229698
Jul-08 10719837 9926 1079.975519
Aug-08 8133926 7359 1105.303166
Sep-08 12189625 11183 1090.01386
Oct-08 11086509 10967 1010.897146
Nov-08 6050646 7247 834.9173451