Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi all,
I am trying to plot a line chart (with markers displayed at each data value) and present the series in "column" format with the following data: A B C D E F G H I J Zone 1 0 80 100 100 0 100 100 100 100 100 Zone 2 25 30 26 12 40 45 22 29 46 18 Zone 3 75 70 74 88 60 55 78 71 54 82 By doing so, I get the Zone 1 - 3 presented as x axis. I would like to make Zone 1-3 to be on y axis instead but can't seem to direct Excel to do so despite trying different ways e.g. retyping the data as follows: Zone 1 Zone 2 Zone 3 A 0 25 75 B 80 30 70 .... and so on Would appreciate if any advice please. Thanks! Davin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 Line Chart - Switch Axis Position | 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 | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
How do I set Line chart y Axis variable X axis value? | Charts and Charting in Excel | |||
How do I switch the axis values in my chart | Charts and Charting in Excel |