Combining different charts on a single chart
 

Hello,

I would like to combine different charts on a single chart, like having
several subplots on a single chart.

I admit the description is not very useful, so I attached what I am
aiming for (a heat map from the IMF), and in the excel file with what
kind of data I am dealing with. To plot a single chart it is working
well (for ex. for charting TS A or TS B), but ideally I would like to
combine TS A and TS B on the same chart.

Any ideas ?

Cheers,
Charles


+-------------------------------------------------------------------+
|Filename: Goal - Heat Map.jpg |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=162|
+-------------------------------------------------------------------+

--
matsolbach
------------------------------------------------------------------------
matsolbach's Profile: http://www.thecodecage.com/forumz/member.php?userid=409
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105406

Answer: Combining different charts on a single chart
 

Hi Charles,

Thanks for reaching out! It sounds like you want to create a chart that combines multiple subplots into one chart. This is definitely possible in Excel.

Here are the steps you can follow:

1. Select the data for both TS A and TS B.
2. Click on the "Insert" tab in the Excel ribbon.
3. Click on the "Recommended Charts" button.
4. In the "All Charts" tab, select the "Combo" chart type.
5. In the "Combo" chart type, select the "Clustered Column - Line" chart subtype.
6. Click "OK" to create the chart.
7. You should now have a chart that shows both TS A and TS B on the same chart.
8. To customize the chart further, you can right-click on any element of the chart (e.g. the legend, the axis labels, etc.) and select "Format [element name]" to make changes.

Let me know if you have any questions or if there's anything else I can do to assist you.

Best regards,
[Your Name]

Combining different charts on a single chart
 

Check my reply to your other post at excelforum
http://www.excelforum.com/excel-gene...nt-charts.html

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"matsolbach" wrote in message
...

Hello,

I would like to combine different charts on a single chart, like having
several subplots on a single chart.

I admit the description is not very useful, so I attached what I am
aiming for (a heat map from the IMF), and in the excel file with what
kind of data I am dealing with. To plot a single chart it is working
well (for ex. for charting TS A or TS B), but ideally I would like to
combine TS A and TS B on the same chart.

Any ideas ?

Cheers,
Charles


+-------------------------------------------------------------------+
|Filename: Goal - Heat Map.jpg |
|Download:
http://www.thecodecage.com/forumz/attachment.php?attachmentid=162|
+-------------------------------------------------------------------+

--
matsolbach
------------------------------------------------------------------------
matsolbach's Profile:
http://www.thecodecage.com/forumz/member.php?userid=409
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=105406

Combining different charts on a single chart
 

matsolbach;376671 Wrote:
Hello,

I would like to combine different charts on a single chart, like having
several subplots on a single chart.

I admit the description is not very useful, so I attached what I am
aiming for (a heat map from the IMF), and in the excel file with what
kind of data I am dealing with. To plot a single chart it is working
well (for ex. for charting TS A or TS B), but ideally I would like to
combine TS A and TS B on the same chart.

Any ideas ?

Cheers,
Charles

Post in only one forum


Hi, please avoid crossposting
I recommend you read following article 'A message to forum cross
posters | Excelguru.ca' (http://www.excelguru.ca/node/7)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105406

Combining different charts on a single chart
 

Thanks for the answer, exactly what I was looking for !

Cheers,
Charles


--
matsolbach
------------------------------------------------------------------------
matsolbach's Profile: http://www.thecodecage.com/forumz/member.php?userid=409
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105406