2010
10.21

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

 

Incoming Search Term

Advertise Here

 

No Comment

Add Your Comment