Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Moxy1980
 
Posts: n/a
Default Simple one, its just that I'm thick!


How do I have a bar graph where 2 sets of information are laid over each
other. Similar to a stacked chart but with both sets starts on 0.

Please help!

Similar to the 3-D column standard option but not in 3-D!!


--
Moxy1980
------------------------------------------------------------------------
Moxy1980's Profile: http://www.excelforum.com/member.php...o&userid=28075
View this thread: http://www.excelforum.com/showthread...hreadid=477927

  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default Simple one, its just that I'm thick!

Use the clustered chart type, double click one series, and on the Options tab,
change overlap to 100%.

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

Moxy1980 wrote:

How do I have a bar graph where 2 sets of information are laid over each
other. Similar to a stacked chart but with both sets starts on 0.

Please help!

Similar to the 3-D column standard option but not in 3-D!!



  #3   Report Post  
Moxy1980
 
Posts: n/a
Default Simple one, its just that I'm thick!


Cheers mate


--
Moxy1980
------------------------------------------------------------------------
Moxy1980's Profile: http://www.excelforum.com/member.php...o&userid=28075
View this thread: http://www.excelforum.com/showthread...hreadid=477927

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
simple if then function amy Excel Worksheet Functions 4 July 6th 05 05:36 PM
Simple Simple Excel usage question BookerW Excel Discussion (Misc queries) 1 June 23rd 05 10:06 PM
Help with what should be a simple formula B Millar via OfficeKB.com Excel Worksheet Functions 2 June 16th 05 04:18 PM
Optimize simple macro Biff Excel Worksheet Functions 7 June 2nd 05 01:15 AM
Simple But Stumped Brian Keanie Excel Discussion (Misc queries) 3 February 5th 05 02:56 AM


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