Forum Discussion

jose75's avatar
jose75
Copper Contributor
Apr 21, 2022
Solved

Bar Chart

i can't make my bar chart out of 100%, i select my values and choose my bar chart but it doesn't want to have the maximum 100%. it makes it out of 60% because my values are 55 and 45. Please help, th...
Charting
excel
jose75's avatar
jose75
Copper Contributor
Apr 25, 2022

HansVogelaar 

https://1drv.ms/f/s!ArLEWl-QUCgClVzbi0XKcX89yPr1

Hi,

Please let me know if everything is fine.

Thanks.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 25, 2022

    jose75 , you are welcome, glad to help

  • jose75's avatar
    jose75
    Copper Contributor
    Apr 25, 2022
    Thank you so much Sergei,
    you really helped me out.
  • jose75's avatar
    jose75
    Copper Contributor
    Apr 25, 2022
    yeah i hear you but he solved my problem
    Thank you so much for the effort!
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 25, 2022

    jose75 

    SergeiBaklan has shown you the problem: the two values are data points of the same series. There is no point in using a stacked column chart for that.

    But if you really want, change the chart to a clustered column chart, then double-click the y-axis and set the maximum to 100.

     

    By switching rows and columns, as Sergei suggested, you create two series with one data point each, the two series will add to 100%.

  • jose75's avatar
    jose75
    Copper Contributor
    Apr 25, 2022

     

    no i mean my bar graph is not maxing out of 100 instead it maxes out at 60.

    Thanks for the help.

     

    SergeiBaklan