A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Graph Axes

Thread Tools Display Modes
Old December 8th 04, 08:03 PM
external usenet poster
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
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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

All times are GMT +1. The time now is 05:43 PM.

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