| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Individual column width to represent stacked total
I am charting market share of 9 companies across 13 individual
countries. I have the 13 countries on the x-axis, and %age market share on the y-axis. Columns are all stacked to 100%. What I would like to do is have the width of each individual column vary according to the total units for that country (kinda similar to how a bubble chart would do this if that makes sense) Does anyone know a way to achieve this? Excel 2003 btw :-) |
|
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
Individual column width to represent stacked total
I believe this article explains how to do it.
http://pubs.logicalexpressions.com/P...cle.asp?ID=508 HTH, Barb Reinhardt "DemonFish" wrote: I am charting market share of 9 companies across 13 individual countries. I have the 13 countries on the x-axis, and %age market share on the y-axis. Columns are all stacked to 100%. What I would like to do is have the width of each individual column vary according to the total units for that country (kinda similar to how a bubble chart would do this if that makes sense) Does anyone know a way to achieve this? Excel 2003 btw :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| stacked column with total | Charts and Charting in Excel | |||
| Total on Stacked Column Chart | Excel Discussion (Misc queries) | |||
| Resize individual cells w/o changing the entire column width | Excel Discussion (Misc queries) | |||
| What does the 8.43 and 12.75 represent in height and width of cell | Excel Discussion (Misc queries) | |||
| How do I change the width of an individual cell? | Excel Discussion (Misc queries) | |||
Linear Mode
