Results 1 to 8 of 8

Thread: Monthly Chart with Values & Percentages

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member
    Join Date
    Jun 2012
    Posts
    80
    Rep Power
    13

    Monthly Chart with Values & Percentages

    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.

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Add a new series for Target and make it secondary axis. Also change the chart type as Line chart.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Member
    Join Date
    Jun 2012
    Posts
    80
    Rep Power
    13
    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

  4. #4
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    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.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  5. #5
    Member
    Join Date
    Jun 2012
    Posts
    80
    Rep Power
    13
    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?

  6. #6
    Member
    Join Date
    Jul 2012
    Posts
    55
    Rep Power
    13
    Right click on green line and choose add date...

    See attach
    Attached Files Attached Files

  7. #7
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Set the data labels for this series and make the line color no line.
    Last edited by Admin; 01-08-2015 at 02:36 PM.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  8. #8
    Member
    Join Date
    Jun 2012
    Posts
    80
    Rep Power
    13
    Thanks a lot. I got my graph as I wanted.

    Really appreciate your help.

Similar Threads

  1. Custom Charts in Excel :: Gauge Chart (aka Dial/Speedometer Chart)
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 08-07-2013, 05:16 PM
  2. Ageing Monthly Bracket Calculator
    By msiyab in forum Excel Help
    Replies: 9
    Last Post: 07-01-2013, 12:50 PM
  3. Replies: 4
    Last Post: 06-10-2013, 01:27 PM
  4. Replies: 2
    Last Post: 04-24-2013, 08:06 PM
  5. Excel Chart Showing Values on Angle: Nightingale Chart
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 10-17-2012, 06:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •