LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
SRS
 
Posts: n/a
Default Newbie - Combine two values to one bar?

Hmmm...

This is a challenge to put into words, but here goes.

I have to make a simple bar graph showing sales results from our ten clients.

All I want for each client is a bar with what we budgeted their sales would
be for the year, and...one bar next to that one that actually shows two
values - sales year-to-date and then ON TOP of that sales expected by year
end.

So, for example...if client "Alpha" has a sales budget of $100,000 we'd see
a bar showing $100K, and if their sales year-to-date is $80,000 and we expect
$30,000 more in sales the bar next to the "budget" bar would show a bar up to
$80,000 in one color (for sales year to date) and then ON TOP of that bar,
another bar (different color for sales expected) showing an additional
$30,000 for a TOTAL of $110,000.

So as we look at the chart we instantly see what we budgeted, but with the
year-to-date and expected sales combined on a bar next to the budgeted bar,
we see where we'll end up.

I really hope this makes sense.

Thank you very much for your help!
 
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
Using Match function with duplicate values in an array Richard Excel Worksheet Functions 3 April 22nd 23 07:45 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
Combine FREQUENCY and SUM of Associated Values MichaelC Excel Worksheet Functions 3 July 3rd 05 01:54 AM
combine "category labels" & "values" in legend danielo Excel Discussion (Misc queries) 4 February 9th 05 01:11 AM
Newbie to charts question - projecting values between data points 38N90W Excel Discussion (Misc queries) 3 January 6th 05 05:15 AM


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