Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Representing Dual Data in a Stacked Bar Chart
Here is my data:
Location Flowers Trees Year 1 Year 2 Year 1 Year 2 Texas 55 63 36 14 Florida 67 75 24 21 NJ 32 27 52 10 Colorado 35 41 35 9 California 84 126 78 39 I want a stacked bar chart that shows Flowers & Trees for Year 1 next to another stacked bar for Year 2, grouped by location shown along the X axis. Please help, all I could come up with is a Stacked bar for Year 1, overlayed by 2 separate line graphs for Flowers/Yr2 and Trees/Yr2. -- VB |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Representing Dual Data in a Stacked Bar Chart
On Wed, 20 Jun 2007, in microsoft.public.excel.charting,
VB said: I want a stacked bar chart that shows Flowers & Trees for Year 1 next to another stacked bar for Year 2, grouped by location shown along the X axis. Please help, all I could come up with is a Stacked bar for Year 1, overlayed by 2 separate line graphs for Flowers/Yr2 and Trees/Yr2. You have the power to change the chart type of any series, so don't feel that you are stuck with lines. Click on the line series, select "Chart type" and choose Stacked Bar to change them. Getting them in the position you want is then a matter of sorting the series in the right order. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart with dual Y axis data | Excel Worksheet Functions | |||
representing multi category in a column chart | Charts and Charting in Excel | |||
Need a stacked bar chart with each stack representing a month | Charts and Charting in Excel | |||
Dual Axis stacked bar. | Charts and Charting in Excel | |||
Creating a chart representing hours used | Charts and Charting in Excel |