Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-01-2021, 04:02 AM
laith93 laith93 is offline Using certain values in custom number format for vertical chart axis? Windows 10 Using certain values in custom number format for vertical chart axis? Office 2019
Competent Performer
Using certain values in custom number format for vertical chart axis?
 
Join Date: Jul 2021
Posts: 117
laith93 is on a distinguished road
Default Using certain values in custom number format for vertical chart axis?

Hi All,
Please look at this chart

img_84.png

I want to remove the percentage symbol (%) from vertical axis, after googling for a time, many people recommended using these custom number formats:
###0, [=100]0″%”;0_%, [>=100] ###0;, [=100]0;0_
I tried all, but not to produce my desired need.
if this is impossible, then how to make certain values appear on this axis (for example: 0-100)

You can download the attachment file (Doc2) to apply on it


With special thank
Attached Files
File Type: docx Doc2.docx (29.8 KB, 7 views)
Reply With Quote
  #2  
Old 08-01-2021, 05:52 PM
Guessed's Avatar
Guessed Guessed is offline Using certain values in custom number format for vertical chart axis? Windows 10 Using certain values in custom number format for vertical chart axis? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I can't see a way to change it via formatting.

If it was me, I would convert the underlying data numbers to totaling 100 based on their shares and plot it as a regular stacked bar chart.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 08-01-2021, 09:57 PM
laith93 laith93 is offline Using certain values in custom number format for vertical chart axis? Windows 10 Using certain values in custom number format for vertical chart axis? Office 2019
Competent Performer
Using certain values in custom number format for vertical chart axis?
 
Join Date: Jul 2021
Posts: 117
laith93 is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
I can't see a way to change it via formatting.
Thanks Mr. Guessed for your response

Of course, there are Stacked columns and a 100% Stacked column
Stacked columns display actual values, which I worked on 50 samples.
on the other hand, my supervisor wants a 100% Stacked column to display data in percentage and also removing the percentage symbol from the vertical axis.


Quote:
Originally Posted by Guessed View Post
If it was me, I would convert the underlying data numbers to totaling 100 based on their shares and plot it as a regular stacked bar chart.
Mr. Guessed my current solution is using a text box filled with values (0 - 100), but it's not a professional way.
Reply With Quote
  #4  
Old 08-01-2021, 10:28 PM
Guessed's Avatar
Guessed Guessed is offline Using certain values in custom number format for vertical chart axis? Windows 10 Using certain values in custom number format for vertical chart axis? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

This is how I did it - by using a Stacked Column chart instead of a 100% Stacked Column chart. You need to convert your actual numbers to proportional values totalling 100.
Attached Images
File Type: png 2021-08-02_15-25-21.png (71.6 KB, 14 views)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 08-01-2021, 10:46 PM
laith93 laith93 is offline Using certain values in custom number format for vertical chart axis? Windows 10 Using certain values in custom number format for vertical chart axis? Office 2019
Competent Performer
Using certain values in custom number format for vertical chart axis?
 
Join Date: Jul 2021
Posts: 117
laith93 is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
You need to convert your actual numbers to proportional values totalling 100.
Thanks for your work

Excuse me Mr. Guessed, how to convert actual numbers to proportional values totaling 100?

I was already converted my data to totaling of 100 by using multiply function (ex: 0.5*100 =50)
look at this:
img_86.png
Reply With Quote
  #6  
Old 08-02-2021, 04:17 PM
Guessed's Avatar
Guessed Guessed is offline Using certain values in custom number format for vertical chart axis? Windows 10 Using certain values in custom number format for vertical chart axis? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

That works when the total of the numbers was 50. I assume you used some kind of formula to arrive at the E:F columns and then it is as easy as multiplying them by 100.

When the sum of the numbers varies you would use a formula like the following in I2
=100*B2/Sum($B2:$D2)

You can then copy that formula across and down to build the table.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 08-02-2021, 11:31 PM
laith93 laith93 is offline Using certain values in custom number format for vertical chart axis? Windows 10 Using certain values in custom number format for vertical chart axis? Office 2019
Competent Performer
Using certain values in custom number format for vertical chart axis?
 
Join Date: Jul 2021
Posts: 117
laith93 is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
When the sum of the numbers varies you would use a formula like the following in I2
=100*B2/Sum($B2:$D2)

You can then copy that formula across and down to build the table.
Thanks my bro
Reply With Quote
Reply

Tags
microsoft word 2019, office 2013, word 16

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Axis on line chart includes dates with no data under them, but text axis causes data to clump jcyo233 Excel 6 10-18-2018 04:49 AM
my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. jalea148 Excel 3 01-06-2017 09:04 AM
Using certain values in custom number format for vertical chart axis? Format Chart X axis - inconsistent values TimTDP Excel 2 12-01-2015 02:56 AM
Secondry Axis overlapping in bar chart dual axis in Powerpoint 2010 sharath_ms PowerPoint 0 07-08-2013 10:06 PM
Custom Number Format for Chart deadrxn24 Word 4 03-18-2012 05:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft