ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Simple one, its just that I'm thick! (https://www.excelbanter.com/charts-charting-excel/51473-simple-one-its-just-im-thick.html)

Moxy1980

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


Jon Peltier

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!!




Moxy1980

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



All times are GMT +1. The time now is 06:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com