browse by category or date

Yesterday, a colleague requested my assistance to modify an Excel chart. She has the following chart:
chart.profit
The data: (not the real data, of course :D)

JanFebMarchAprMay
Cost1500035000450008500060000
Sales1700045000500009000070000
Profit2000100005000500010000
Profit%12%22%10%6%14%

She wanted to add another series of data for next year profit target:

JanFebMarchAprMay
Cost1500035000450008500060000
Sales1700045000500009000070000
Profit2000100005000500010000
Profit%12%22%10%6%14%
Target Next Yr.%12%16%20%24%30%

So how do we incorporate the new row?

  1. Add the new series.
    Right click on the chart, click ‘Source Data’ chart.profit.2
    Click Add button, and fill up the fields as indicatedchart.profit.3
  2. Modify the series
    If you don’t have Chart toolbar as shown below, click View – Toolbars – Chart. If you already have it, select the newly created series. chart.profit.4
    Change the chart type. chart.profit.5Change the chart properties.chart.profit.6

Final result:
chart.profit.7

GD Star Rating
loading...
How to Draw Excel Chart with Two Different Y-Axis, 3.0 out of 5 based on 1 rating

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

ms excel

No Comment

Add Your Comment