#1   Report Post  
Old December 8th 04, 09:03 PM
Posts: n/a
Default Graph Axes


I am having this exact same issue as below. I need the categories on the X
axis switched with the numerical values on the Y axis. I saw the response
below to change to bar instead of column. My problem is that I cannot use a
bar graph...instead I need to use a line graph or scatter graph. I cannot
find a way to do this in the entire Office suite (Word, PowerPoint or Excel).
Does anyone have a solution?

Thanks in advance,


"Mark Buonanno @ HP" wrote:

am trying to get the categories that I can get in words that appear on the
xaxis to be simply switched with the numerical values I get on the Y axis. I
know about switching row and column but this just puts the categories into a
legend. I want the categories to be like they are on the x axis but to be on
the y axis. I spoke with lots of people and this is seemingly an impossible
task. Excel only allows the categories to be on the x axis. I used to use
Cricket Graph ten years ago and that could allow you to switch the axis
whenever you chose to do so even after the graph was plotted. Anybody got an
idea how to do this. I'm working with the scatter graph and can't seem get
this to happen.

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
Scatter Graph - Data Label Problems TBD Charts and Charting in Excel 2 January 16th 05 06:08 PM
Bar graph values keep changing Mike82j2000 Charts and Charting in Excel 1 January 6th 05 02:27 PM
How do I plot an XY (scatter) graph with two Y axes? PeterAtLufbra Charts and Charting in Excel 1 December 22nd 04 03:03 PM
Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 02:09 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 06:19 PM

All times are GMT +1. The time now is 03:53 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017