+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting the number format of a chart

  1. #1
    Registered User
    Join Date
    07-19-2017
    Location
    Sofia
    MS-Off Ver
    2016
    Posts
    2

    Conditional formatting the number format of a chart

    Hi all,

    I'm trying to find a solution for a chart in PowerPoint.

    I'm trying to achieve the following. I have a column chart and I want to force it to show only the values <3% with 1 decimal place, and all the other values with 0 decimal places. I've used conditional formatting to format data, but I can't seem to find a way to force PowerPoint to display the values based on the rule I've set. Is this even possible, or would I have to do it manually like I did for the example below?

    1678965613350.png
    1678965764695.png
    Last edited by IvoBrasil; 03-22-2023 at 04:49 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Conditional formatting the number format of a chart

    In the chart's data sheet use a custom number format

    [>=0.03]0%;0.0%
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-19-2017
    Location
    Sofia
    MS-Off Ver
    2016
    Posts
    2

    Re: Conditional formatting the number format of a chart

    Thank you so much! You saved me tons of time!

+ 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. Conditional formatting for specific phone number format
    By casey1deacon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-10-2023, 04:44 PM
  2. Conditional formatting for specific phone number format
    By nwpassage in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-10-2015, 12:30 PM
  3. [SOLVED] Conditional formatting for number format
    By Copenworld in forum Excel General
    Replies: 3
    Last Post: 03-02-2014, 08:49 PM
  4. Conditional formatting Chart Axis number type
    By Dial1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-09-2013, 07:11 AM
  5. How to copy cell format done by Conditional Formatting to Chart?
    By Excel4Everything in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2013, 08:21 AM
  6. Conditional Number Formatting Not Working for Chart Value Labels
    By michael_watson in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-14-2012, 05:29 AM
  7. Make conditional formatting Macro dependent on cell number format
    By jbyrne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2010, 10:26 AM

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