custom chart type column - column on 2 y axes

custom chart type column - column on 2 y axes

Post by Chris Hauc » Fri, 19 Dec 2003 12:28:15


I've been trying to build a chart in a presentation that
has 2 y axes. The first is a revenue figure and the
second axes is a proportion of the population
participating in the sport. I've looked through the
available custom charts and only find an option for a
column - line chart. Neither sets of data represent
time, so the line chart is all wrong. Ideally, I would
have 2 columns for each category. I can achieve this,
but the secondary y axes (being a percentage) columns are
too small to see differentiation between the categories.
I would love it if someone would send me a column -
column chart on 2 y axes so I could see how it is done.

Help...I need this for a presentation deck in the next
few days and have to replicate this chart many times!
 
 
 

custom chart type column - column on 2 y axes

Post by Umlhbm » Fri, 19 Dec 2003 20:21:17

Chris, I wish I had your figures to play around with doing the chart.

If I get a problem that I cannot solve in PowerPoint I do the chart first in Excel to see if it is actually possible / meaningful. If it is possible in Excel it should be possible in PowerPoint. I have found the custom charts to be very limiting. It only gives a start to doing a specific chart. Also, it is easy to mess up a chart when working with the secondary access. I always insert a duplicate slide after I have done my initial changes and work on the duplicate to ensure I still have my initial changes (the undo does not work too well in PowerPoint). If the chart is a combination chart (bar / histogram and line) and I only want bars (this does not apply to stacked bars as it can't be combined) I rightclick on the line and change it to a bar by choosing the correct chart type for the line. I avoid 3D types - only use them if the data is simple and I want to add effect. I have found it also useful to draw the chart first on a piece of paper and interpret it to see if it has the correct meaning (statistically).




I've been trying to build a chart in a presentation that
has 2 y axes. The first is a revenue figure and the
second axes is a proportion of the population
participating in the sport. I've looked through the
available custom charts and only find an option for a
column - line chart. Neither sets of data represent
time, so the line chart is all wrong. Ideally, I would
have 2 columns for each category. I can achieve this,
but the secondary y axes (being a percentage) columns are
too small to see differentiation between the categories.
I would love it if someone would send me a column -
column chart on 2 y axes so I could see how it is done.

Help...I need this for a presentation deck in the next
few days and have to replicate this chart many times!

 
 
 

custom chart type column - column on 2 y axes

Post by Umlhbm » Fri, 19 Dec 2003 21:26:08

I have found the address below on the excel discussion forum and have gone into it to see what it looks like. It's very good. Maybe you could find your solution there. http://www.yqcomputer.com/
 
 
 

custom chart type column - column on 2 y axes

Post by Andy Pop » Fri, 19 Dec 2003 21:55:10

Hi Chris,

Try this,
insert a graph and change the chart type to Cluster Column.
Make sure the chart contains 4 sets of columns.

Select the 3rd set of columns and change them to the secondary axis.
Repeat for the 4th set of columns. You should now have dataseries 3 and
4 side by side and in front of 1 and 2.

Set the data values for series 2 and 3 to 0. This will then expose the
series 1 and 4 side by side. Format both y axis to suit.

You will also have to sort out the legend, as it contains 4 data series.
Select the legend, select the legend entry and then delete. Be sure not
to select the legend marker as deleting this will delete the data as well.




--

Cheers
Andy

http://www.yqcomputer.com/