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 Stacked/clustered column graph with secondary y axis

Much has been discussed here about how to build this chart, but I
haven't found anything explaining the possibility of combining it with
a second y axis. I want to graph the advertising expenditure and gross
rating points (what would be the return of investment on advertising)
on television for three diaper brands by day part. Day parts would be
represented by the different colors of which columns will consist.
There are 5 of them: day, early, prime, late and over. For each brand,
I want that two data columns. The one to the right will represent the
expenditure in $ and the one to the left the GRPs.

The thing is, there is an abysmal difference between the scale of $
and GRPs. So I want a secondary axis for each column on the right side
of each brand. This means that columns # 2, 4, and 6 will be 'ruled'
by the second y axis and the other columns of odd numbers will be
ruled by the primary y axis.

I hope you can get the idea of what I'm trying to do here. Thanks in
advance for your help.

 
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
Stacked Column with Secondary Axis Mallik Rao Charts and Charting in Excel 1 March 6th 07 11:36 AM
Stacked AND Clustered AND Different axis scales Álvaro Charts and Charting in Excel 0 November 9th 05 05:04 PM
How do I set up a clustered stacked column graph? Is it possible? BradT Charts and Charting in Excel 1 October 18th 05 03:30 AM
How to mix a stacked column and a clustered one on same graph? Armelle Charts and Charting in Excel 1 September 5th 05 01:40 PM
A stacked, clustered bar graph? Robyn Charts and Charting in Excel 1 April 10th 05 02:03 PM


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