LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default How to manually switch data from x axis to y axis in line chart?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Line Chart - Switch Axis Position sot Charts and Charting in Excel 2 September 27th 07 01:12 PM
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS vijaicbe Charts and Charting in Excel 4 November 9th 06 10:16 AM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
How do I set Line chart y Axis variable X axis value? John T Charts and Charting in Excel 1 April 18th 05 04:36 AM
How do I switch the axis values in my chart Melissa Charts and Charting in Excel 3 February 9th 05 01:55 PM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"