browse by category or date

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

Possibly relevant:

About Hardono

Howdy! I'm Hardono. I am working as a Software Developer. I am working mostly in Windows, dealing with .NET, conversing in C#. But I know a bit of Linux, mainly because I need to keep this blog operational. I've been working in Logistics/Transport industry for more than 11 years.

Incoming Search

excel charts, excel chart

No Comment

Add Your Comment