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.

Sales Report - Example.xlsx

[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. Sales Report - Example.xlsx

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

[Ingolf]

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

See attach

[Admin]

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

[msiyab]

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

Really appreciate your help.