+ Reply to Thread
Results 1 to 2 of 2

combining data to make a stacked, clustered bar chart Excel 2013

Hybrid View

spartandefender combining data to make a... 03-07-2016, 07:16 AM
ben_hensel Re: combining data to make a... 03-07-2016, 11:00 AM
  1. #1
    Registered User
    Join Date
    01-29-2015
    Location
    UK
    MS-Off Ver
    2013
    Posts
    4

    combining data to make a stacked, clustered bar chart Excel 2013

    Hi,

    Can anyone suggest a way to make a stacked clustered chart on Excel 2013? I essentially want these three charts on one graph. I have a change of Pinch Point (pp) for each data range and I need to directly compare them. When pinch point changes, the heat exchange areas of the various components change respectively. So 3 stacked bars for 3MPa etc. See images below.

    No Knowledge of thermodynamics required I hope.

    Thank you.

    Capture.JPG

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: combining data to make a stacked, clustered bar chart Excel 2013

    Try on Jon Peltier's guide to clustered & stacked column & bar charts and see how it suits you.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to make a clustered column stacked bar chart?
    By Jumana Nooruddin in forum Excel General
    Replies: 1
    Last Post: 11-11-2014, 09:41 AM
  2. Combining Clustered and Stacked on one data set.
    By smcneil1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-12-2014, 04:30 AM
  3. How to make a Clustered Cylinder Chart in Excel 2013?
    By Anodos in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-11-2014, 04:35 PM
  4. Clustered-stacked column chart in Excel 2007?
    By bmurata in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-10-2010, 06:49 PM
  5. Combining Stacked and Clustered Column Charts
    By ChemistB in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-02-2008, 09:59 AM
  6. Stacked AND clustered chart?
    By lakegoddess in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-30-2007, 05:09 AM
  7. [SOLVED] Can I combine a stacked and clustered column chart in Excel
    By Tim Donnelly in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-07-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1