Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tim
 
Posts: n/a
Default How do I make a stacked column chart with side-by-side comparison.

Looking at making a stacked column chart. But I want it to look like a
clustered column, able to compare 2 items next to each other. Any thoughts?
  #2   Report Post  
Barb R.
 
Posts: n/a
Default

Take a look at Jon Peltier's site. He has lots of examples of different
chart types.

I'll start you out on the page you might want to look at.

http://www.peltiertech.com/Excel/Cha...mboCharts.html

"Tim" wrote:

Looking at making a stacked column chart. But I want it to look like a
clustered column, able to compare 2 items next to each other. Any thoughts?

  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

Here's a page with links to clustered-stacked charts:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Barb R. wrote:

Take a look at Jon Peltier's site. He has lots of examples of different
chart types.

I'll start you out on the page you might want to look at.

http://www.peltiertech.com/Excel/Cha...mboCharts.html

"Tim" wrote:


Looking at making a stacked column chart. But I want it to look like a
clustered column, able to compare 2 items next to each other. Any thoughts?

  #4   Report Post  
aztimm
 
Posts: n/a
Default

Thank you both for your replies. Right after I posted, I did some more
searching and found some of Jon's earlier messages. With so many people
wanting this, you'd think it would be easier to do...

Anyway, I really WOW'ed my boss with this. She's pretty much an Excel guru
and had never seen this done before.

Thanks!

Tim

"Jon Peltier" wrote:

Here's a page with links to clustered-stacked charts:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Barb R. wrote:

Take a look at Jon Peltier's site. He has lots of examples of different
chart types.

I'll start you out on the page you might want to look at.

http://www.peltiertech.com/Excel/Cha...mboCharts.html

"Tim" wrote:


Looking at making a stacked column chart. But I want it to look like a
clustered column, able to compare 2 items next to each other. Any thoughts?


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
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
How do I combine a line and a percentage stacked column chart? Liza Charts and Charting in Excel 1 February 3rd 05 02:40 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 08:25 PM
Making Special "Stacked Column" Chart Chaplain Doug Charts and Charting in Excel 3 December 10th 04 05:31 PM
Copying the contents of a column into a chart Richard Excel Worksheet Functions 1 November 16th 04 03:39 PM


All times are GMT +1. The time now is 10:36 AM.

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"