Monthly Chart with Values & Percentages

[msiyab]

Hi All,

I have a monthly sales excel with the following headers:
Month, Leads, Target, Sales Amt, Revenue, Target Achieved)

The graph currently shows only 2 bars separately for Sales Amt & Revenue. Now, I would like to have a percentage (under the header 'Target Achieved') above these 2 bars for the corresponding months. Just FYI, the value under the header 'Target' is not same throughout the year.

Kindly help.

[Admin]

Add a new series for Target and make it secondary axis. Also change the chart type as Line chart.

[msiyab]

Here is an example of the file I use. As you can see, I have added the Target Achieved (18%) manually into the chart. Is it possible to showcase that percentage in that way or any other way.

I am really bad with graphs, so any help will be appreciated.

1719

[Admin]

I can't upload the workbook. You can do it manually...

1. Convert the chart type from clustered cylinder to clustered columne
2. Right click on chart > Select data > Replace the range $D$3:$E$15 with $D$3:$F$15
3. Click on any bar on chart > press up/down arrow keys to select the 'Target Achieved' series
4. Once you selected the series, right click on the selected series > Format Data Series > Check secondary axis (if you can't select the series, change any of the target value to 10000%)
4. Again right click on the same series >Change series chart type > select line chart



You are done.

[msiyab]

Thanks for the help.

I followed all your steps and ended up with this graph. 1720

Its fine but is it possible to get the percentages (in figures) on respective points on the line graph ONLY?

[Admin]

Set the data labels for this series and make the line color no line.

[Ingolf]

Right click on green line and choose add date...

See attach

[msiyab]

Thanks a lot. I got my graph as I wanted.

Really appreciate your help.