2009
08.05

How to Combine Different Excel Charts

A colleague asked for my help yesterday. He wants to have a chart that consists of bar chart and smooth-line chart. Since I don’t rate my MS Excel skill highly, I told him to give me some time to do simulation (read: Trial-and-Error)

Assume we have the following data:

 

Jan

Feb

Mar

Apr

Sales 2008

12

56

90

34

Sales 2009

23

87

43

83

Overtime 2008

23

45

37

68

Overtime 2009

11

32

43

12

Below is the final result that he wanted:

excel-chart

To do that, first we need to plot the data as XY (Scatter) – Smooth Line chart. I assume you know how to plot chart with data series. By now, we should have this:

excel-chart2

Select one of the series that you want to change into bar chart. You can do that by clicked the series’ line in the chart, or open the chart toolbar.

excel-chart3

It’s a simple trick that I only know about it yesterday :D. I hope you will find it useful.

GD Star Rating
loading...
How to Combine Different Excel Charts, 3.5 out of 5 based on 2 ratings

Incoming Search Term

excel charts, excel chart

Advertise Here

No Comment

Add Your Comment