Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Office XP - "help" doesn't . I want to make a second Value axis

"Make a second value axis". I don't get an expected choice in the Format
menu. Help tells me to use "Selected data series" on the "Format" menu. It
is not there. Is it just me?

Baffled.

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Office XP - "help" doesn't . I want to make a second Value axis

Select a series, use Format menu Selected Data Series. On the Axis tab,
select Secondary.

Note, you must have at least two series, one each for primary and secondary
axis.

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


"gordon158" wrote in message
...
"Make a second value axis". I don't get an expected choice in the Format
menu. Help tells me to use "Selected data series" on the "Format" menu.
It
is not there. Is it just me?

Baffled.



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default Office XP - "help" doesn't . I want to make a second Value axis

You need to select one of the series in the graph before that entry appears
in the Format menu. If you right-click on the series you can go directly
from the context-sensitive menu.
--
David Biddulph

"gordon158" wrote in message
...
"Make a second value axis". I don't get an expected choice in the Format
menu. Help tells me to use "Selected data series" on the "Format" menu.
It
is not there. Is it just me?

Baffled.



Reply
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
Can you make a "split" or broken y-axis on a graph in Excel? question Charts and Charting in Excel 2 August 30th 07 11:46 PM
make "F51668H200AU" into "F5166-8H200AU" fitzu Excel Discussion (Misc queries) 6 August 11th 06 11:46 PM
Make "Edit" mode default, rather than "Enter"? Greg Boettcher Excel Discussion (Misc queries) 1 July 27th 06 01:46 AM
How do I make a "0" appear on the Y-axis of my graph? magikid Excel Discussion (Misc queries) 3 July 19th 06 01:27 AM
how can I make an excel cell "mark" or "unmark" when clicked on? Rick Excel Discussion (Misc queries) 6 January 8th 06 10:15 PM


All times are GMT +1. The time now is 08:21 AM.

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

About Us

"It's about Microsoft Excel"