Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / November 2003

Tip: Looking for answers? Try searching our database.

Paired Bar Charts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
thehut - 07 Nov 2003 23:48 GMT
Does anyone know how to make paired bar charts in Excel.  For example I
would like to show sales for a particular product with the
corresponding profit under (or left/right).  Is there an easy way to do
this?

Thanks!

------------------------------------------------
Jon Peltier - 08 Nov 2003 05:12 GMT
Do you want two separate charts?  Make two charts, embedded in a
workbook, then drag them around to line them up.  Hold Alt to glue the
chart to the cell boundaries, or use the various options on the Align or
Distribute command on the Draw menu (Drawing command bar) to align
charts with each other.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> Does anyone know how to make paired bar charts in Excel.  For example I
> would like to show sales for a particular product with the
> corresponding profit under (or left/right).  Is there an easy way to do
> this?
>
> Thanks!
dvt - 09 Nov 2003 14:44 GMT
> Does anyone know how to make paired bar charts in Excel.  For example I
> would like to show sales for a particular product with the
> corresponding profit under (or left/right).  Is there an easy way to do
> this?

My interpretation of your question was a wee bit different than Jon's.  I
think you want a Clustered Column or Clustered Bar chart (to use Excel's
terms).  I'll assume your data for one set of columns is in A1:A10 and the
other data set is in B1:B10.  Select the whole range (A1:B10) and start
the chart wizard (Insert | Chart on the menu).  Select the column chart
(or bar chart for horizontal bars) and the Clustered Column option (the
top left choice).  Follow the wizard through the rest of the process.  
Write back if you have more questions.

Signature

Dave
dvt at psu dot edu

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.