View Single Post
  #1   Report Post  
Old May 20th 09, 11:17 PM posted to microsoft.public.excel.charting
Chart Explorer Chart Explorer is offline
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default Different widths for each column in a 100% stacked column chart

I would like to present a chart that has 3 columns of data with each column
being the same height and each column being split into different components
(i.e. a 'typical' 100% stacked column chart). Each column represents a
different market (split between the players in that particular market) and
the markets are of diferent size. What I would like to do is make the width
of each column vary depending on the size of the market. Effectively the
height of the columns is the same and the vertical splits reflect the
relative size of the components within each column but in addition I would
like the width of the columns to reflect the relative size of each market. I
have seen this in a Powerpoint presentation before but assume it was lifted
from Excel. I have Office 2007.