LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
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 02:03 PM


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

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

About Us

"It's about Microsoft Excel"