#1   Report Post  
Old May 19th 09, 04:17 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 9
Default Dual Bar Chart

I have a simple table with Sales, several Cost-categories and Result per
month over one year. How do I create two columns per month, one for Sales and
one for the Cost-catergories, so that the difference in hight of these two
columns represent my Result per month?

  #2   Report Post  
Old May 19th 09, 05:04 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Dual Bar Chart

Perhaps you want a clustered-stacked column chart?
http://peltiertech.com/WordPress/clu...column-charts/

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Ingo" wrote in message
...
I have a simple table with Sales, several Cost-categories and Result per
month over one year. How do I create two columns per month, one for Sales
and
one for the Cost-catergories, so that the difference in hight of these two
columns represent my Result per month?





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
How do I set dual units (SI and FPS) on a chart Zakaria Charts and Charting in Excel 1 January 17th 08 04:22 AM
Representing Dual Data in a Stacked Bar Chart VB Charts and Charting in Excel 1 June 20th 07 10:14 PM
Dual x-axis chart John Broderick Charts and Charting in Excel 2 July 22nd 06 02:58 AM
Chart with dual Y axis data El Bee Excel Worksheet Functions 1 July 6th 06 08:22 PM
How do I create a dual axes column chart in Excel Alok Charts and Charting in Excel 1 May 17th 05 06:11 PM


All times are GMT +1. The time now is 02:27 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017