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: 3
Default Secondary y-axis for certain x-axis categories (not by series)

Hi:

I have the data set up similar to this:

Group 1 Group 2 Group 3
A 1 1.5 0.8
B 5 3.2 2.5
C 4 6.7 4
D $35 $20 $56
E $42 $36 $29

I want to put all three series into one bar chart with categories A, B, C,
D, E across the x-axis. I want to have 2 y-axes, one for categories A, B, C
and one for categories D & E. However, when I use the "Secondary Axis"
option, it seems to only allow me to choose a series (Group 1, Group 2, or
Group 3) for the secondary axis. Is there a method to use the Secondary Axis
feature wtih x-axis categories (and not with a data series)?

Thank you!

~SonzAMonz
 
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
Combination chart: primary data labels obscure line series on secondary axis Uhl Charts and Charting in Excel 3 December 12th 06 08:52 PM
create bar graph with two series and secondary y axis macmullet Charts and Charting in Excel 2 June 5th 06 03:04 AM
Stacked bar for multiple series + secondary axis gilbertcn Charts and Charting in Excel 2 October 25th 05 08:01 AM
Primary/Secondary Axis series count raydenl Charts and Charting in Excel 1 July 28th 05 08:36 AM
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another John Smith Charts and Charting in Excel 7 December 21st 04 08:26 PM


All times are GMT +1. The time now is 05:08 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"