Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to manually switch data from x axis to y axis in line chart? | Charts and Charting in Excel | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |