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.




Reply With Quote
Bookmarks