Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
VB VB is offline
external usenet poster
 
Posts: 10
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default 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
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
Chart with dual Y axis data El Bee Excel Worksheet Functions 1 July 6th 06 08:22 PM
representing multi category in a column chart hokum Charts and Charting in Excel 2 July 6th 05 01:03 PM
Need a stacked bar chart with each stack representing a month KellyT@HLI Charts and Charting in Excel 3 June 14th 05 01:41 PM
Dual Axis stacked bar. Interactive worksheet Charts and Charting in Excel 1 June 7th 05 08:07 PM
Creating a chart representing hours used joemc911 Charts and Charting in Excel 1 February 2nd 05 03:03 PM


All times are GMT +1. The time now is 06:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"