Apr 21 2022 04:19 AM
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, thanks.
Apr 21 2022 06:03 AM
You mean a column chart instead of a bar chart?
If so, did you select a 100% Stacked Column chart?
Apr 21 2022 06:35 AM
Apr 21 2022 06:52 AM
Could you upload a sample workbook demonstrating the problem without sensitive data to a cloud service such as OneDrive, Google Drive, Dropbox or similar. Obtain a link to the uploaded file and post the link in a reply.
Apr 25 2022 12:49 PM
Apr 25 2022 01:50 PM
no i mean my bar graph is not maxing out of 100 instead it maxes out at 60.
Thanks for the help.
Apr 25 2022 02:05 PM
@Sergei Baklan 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%.
Apr 25 2022 02:06 PM
SolutionApr 25 2022 02:45 PM
Apr 25 2022 02:06 PM
Solution