+ Reply to Thread
Results 1 to 5 of 5

My bars are not matching up with percentages on axis

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    MS 2016
    Posts
    599

    My bars are not matching up with percentages on axis

    Hi guys,

    Urgently need help with regards to my percentage axis!

    I have an axis on the left hand side, but my bars/columns are all the same length! I have the percentages populated but they do not fall in line with the axis (basically all the lines are staying at the same height!)

    Can someone please help? Please see workbook attached - refer to the tab which says 'latest'.

    Thanks so much!

    R.
    Attached Files Attached Files
    Thanks,

    R.



  2. #2
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    MS 2016
    Posts
    599

    Re: My bars are not matching up with percentages on axis

    paint12.png

    I suspect it is something to do with the right-hand side. I would be grateful if someone could please advise. Many thanks!!

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,363

    Re: My bars are not matching up with percentages on axis

    Your chart is currently linked to integer data, and I do not see where in the spreadsheet you have calculated the percentages. It looks to me like you need to:

    1) Compute the percentages somewhere convenient in the spreadsheet. I am not sure exactly how you intend to calculate percentages nor where you would like to store those calculations.
    2) Link the chart series to the range where the percentages are calculated.

    Does that help? Do you need help with a formula to compute percentages? Do you need help changing the source data for the chart?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    MS 2016
    Posts
    599

    Re: My bars are not matching up with percentages on axis

    Hi MrShorty,

    I have used formulas. See tab LatestV2 in the workbook attached and the yellow table - this is what I am referencing. It still is not what I am trying to do... I need the columns to be different sized according to the axis!!!

    Thanks so much for offering to help!
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,363

    Re: My bars are not matching up with percentages on axis

    I think I understand. In your formula, you are converting a decimal/fraction to a per cent by multiplying by 100. Then, in your chart, you format the axis as percent, where Excel again "multiplies" by 100 and adds the per cent symbol %. So the chart is seeing values that are hundreds of per cent, and these values do not fit on a 0 to 90% scaled axis. Two possible solutions:

    1) Drop the *100 in your formulas and let Excel's number formatting convert the resulting decimals/fractions to per cent.
    2) Drop the per cent formatting from the axis and show the numbers as general (axis limits 0 to 90, if you still want the axis to show 0 to 90 per cent).

    Either of those approaches should work.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 3 Bars 2 Axis
    By CallumWebley in forum Excel General
    Replies: 6
    Last Post: 03-17-2016, 11:41 AM
  2. [SOLVED] Bar Graph With 2 Axis - Bars On The Primary Axis Overlap Bars On The Secondary Axis
    By Variablez in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-11-2013, 08:38 AM
  3. [SOLVED] Bars overlapping for primary axis data and secondary axis data
    By Lui23 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-19-2013, 05:06 AM
  4. Bar chart with 4 bars on the x-axis
    By Basilspanellis in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-28-2012, 09:55 AM
  5. Replies: 1
    Last Post: 05-03-2006, 09:20 PM
  6. Want graph with 2 axis, but bars overlap when second axis added
    By Gill in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-15-2005, 10:05 AM
  7. [SOLVED] 2 Bars and 2 Y Axis Chart
    By DG in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-03-2005, 11:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1