A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Y Axes



 
 
Thread Tools Display Modes
  #1  
Old June 6th, 2005, 03:17 PM
Tony
external usenet poster
 
Posts: n/a
Default Y Axes

I have a version of Excel 2000 or Greater no sure but here is my problem.
When I used the Chart Wizard, Green and Red do not appear in the Y Axes.
Apples Oranges
Green 4 7
Red 10 9

How do I get Green and Red to appear in the Y Axes instead of the Legend.
Apples and Oranges appear in the X axes ok.

Thanks in advance.
Tony


  #2  
Old June 6th, 2005, 07:46 PM
bj
external usenet poster
 
Posts: n/a
Default

What is the Green and red supposed to signify The Y axis is numeric only It
does not have lable capabilities. There are methods of making it read Red
and Green show on the graph, but it is not automatic

"Tony" wrote:

I have a version of Excel 2000 or Greater no sure but here is my problem.
When I used the Chart Wizard, Green and Red do not appear in the Y Axes.
Apples Oranges
Green 4 7
Red 10 9

How do I get Green and Red to appear in the Y Axes instead of the Legend.
Apples and Oranges appear in the X axes ok.

Thanks in advance.
Tony


  #3  
Old June 6th, 2005, 08:52 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default

See my post in this newsgroup in a concurrent discussion titled "can
you create a chart in excel with alphanumeric data?"

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have a version of Excel 2000 or Greater no sure but here is my problem.
When I used the Chart Wizard, Green and Red do not appear in the Y Axes.
Apples Oranges
Green 4 7
Red 10 9

How do I get Green and Red to appear in the Y Axes instead of the Legend.
Apples and Oranges appear in the X axes ok.

Thanks in advance.
Tony



  #4  
Old June 8th, 2005, 08:31 PM
Tony
external usenet poster
 
Posts: n/a
Default

Tushar
I found you web site interesting but I can figure how to get to newsgroup in
a concurrent discussion titled "can
you create a chart in excel with alphanumeric data?"

I must be doing or looking in the wrong place.

"Tushar Mehta" wrote:

See my post in this newsgroup in a concurrent discussion titled "can
you create a chart in excel with alphanumeric data?"

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have a version of Excel 2000 or Greater no sure but here is my problem.
When I used the Chart Wizard, Green and Red do not appear in the Y Axes.
Apples Oranges
Green 4 7
Red 10 9

How do I get Green and Red to appear in the Y Axes instead of the Legend.
Apples and Oranges appear in the X axes ok.

Thanks in advance.
Tony




  #5  
Old June 9th, 2005, 04:55 AM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

Depending on how it's sorted, scroll up or down to the next thread.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Tony wrote:
Tushar
I found you web site interesting but I can figure how to get to newsgroup in
a concurrent discussion titled "can

you create a chart in excel with alphanumeric data?"


I must be doing or looking in the wrong place.

"Tushar Mehta" wrote:


See my post in this newsgroup in a concurrent discussion titled "can
you create a chart in excel with alphanumeric data?"

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I have a version of Excel 2000 or Greater no sure but here is my problem.
When I used the Chart Wizard, Green and Red do not appear in the Y Axes.
Apples Oranges
Green 4 7
Red 10 9

How do I get Green and Red to appear in the Y Axes instead of the Legend.
Apples and Oranges appear in the X axes ok.

Thanks in advance.
Tony




  #6  
Old June 9th, 2005, 06:15 PM
Tony
external usenet poster
 
Posts: n/a
Default

Jon,
Thanks for your help, I finally figured it out and got it to work.

"Jon Peltier" wrote:

Depending on how it's sorted, scroll up or down to the next thread.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Tony wrote:
Tushar
I found you web site interesting but I can figure how to get to newsgroup in
a concurrent discussion titled "can

you create a chart in excel with alphanumeric data?"


I must be doing or looking in the wrong place.

"Tushar Mehta" wrote:


See my post in this newsgroup in a concurrent discussion titled "can
you create a chart in excel with alphanumeric data?"

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I have a version of Excel 2000 or Greater no sure but here is my problem.
When I used the Chart Wizard, Green and Red do not appear in the Y Axes.
Apples Oranges
Green 4 7
Red 10 9

How do I get Green and Red to appear in the Y Axes instead of the Legend.
Apples and Oranges appear in the X axes ok.

Thanks in advance.
Tony





  #7  
Old June 9th, 2005, 06:15 PM
Tony
external usenet poster
 
Posts: n/a
Default

Tushar,

Thanks for you help, I finally figured it out and I got it to work.

"Tushar Mehta" wrote:

See my post in this newsgroup in a concurrent discussion titled "can
you create a chart in excel with alphanumeric data?"

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have a version of Excel 2000 or Greater no sure but here is my problem.
When I used the Chart Wizard, Green and Red do not appear in the Y Axes.
Apples Oranges
Green 4 7
Red 10 9

How do I get Green and Red to appear in the Y Axes instead of the Legend.
Apples and Oranges appear in the X axes ok.

Thanks in advance.
Tony




 




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 Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I plot an XY (scatter) graph with two Y axes? PeterAtLufbra Charts and Charting 1 December 22nd, 2004 02:03 PM
Excel Charting - reversed axes BigBob General Discussion 1 November 5th, 2004 12:07 PM


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


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