LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Aurora
 
Posts: n/a
Default Stacked Bar with Reg Bar Chart

I am using Excel 2000
I want to create a chart that compares our monthly Sales goal with the sales
by catergory. Ex: $100,000 sales goal (1 bar on the graph) We sell up of 4
different products; prod a, b, c and d. The product sales $$ (ex: A =
25,000; B = 20,000; C = 10,000 and D = 5,000) would be in a stacked bar so as
to see how close we are to our total sales goal. Sold $60,000 compared to
our goal of $100,000. I thought I would need to have 2 axises; one for the
goal and one for the actual sales bars, but I can not figure out how to do
this with a bar graph. Can anyone point me in the right direction? I would
really appreciate any help I can get.

Thank you -- Aurora
 
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 can I combine a stacked bar chart with stacked colum chart? Sin Charts and Charting in Excel 8 December 20th 05 03:50 AM
Stacked Chart help needed [email protected] Charts and Charting in Excel 5 November 14th 05 08:38 PM
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
Create a custom chart, two stacked bars/month w/ two axes? Oscar Charts and Charting in Excel 1 March 21st 05 11:07 PM
How to make a stacked bar chart using time? Jon Peltier Charts and Charting in Excel 0 February 3rd 05 05:56 AM


All times are GMT +1. The time now is 06:59 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"