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:
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:
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.
It’s a simple trick that I only know about it yesterday :D. I hope you will find it useful.
loading...
About Hardono
Incoming Search
excel charts, excel chart