+ Reply to Thread
Results 1 to 4 of 4

Data bars in pivot table for each individual row label

  1. #1
    Registered User
    Join Date
    02-10-2023
    Location
    Newcastle UK
    MS-Off Ver
    Excel 365
    Posts
    20

    Data bars in pivot table for each individual row label

    hi

    i have set up a pivot table to keep an eye on some details for when i use zwift.

    to help visually quickly seeing date increases/decreases I'm using conditional formatting data bars. the only problem is the data bars go from high to low for all the information in the table row. i am wondering is there a way so the data bars only go high to low for each label on the row?

    ive sent an example. so on the table can the data bars only go high to low for the sub section labelled '101'
    and same for 'fast track' etc etc.

    its just i get varied results from each category so would be easier if each section had their own data bar settings.

    hope this makes sense sorry its hard to explain


    best wishes
    gemma
    Attached Files Attached Files
    Last edited by gemmac; 04-20-2024 at 02:38 AM.

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,069

    Re: Data bars in pivot table for each individual row label

    Change the Bar Appearance from "Solid Fill" to "Gradient Fill":

    CF Rule.png

  3. #3
    Registered User
    Join Date
    02-10-2023
    Location
    Newcastle UK
    MS-Off Ver
    Excel 365
    Posts
    20

    Re: Data bars in pivot table for each individual row label

    thanks alot

  4. #4
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,069

    Re: Data bars in pivot table for each individual row label

    You are welcome! Thanks for the Rep and for marking the thread "Solved".

+ 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. Replies: 3
    Last Post: 07-19-2018, 03:50 PM
  2. Replies: 1
    Last Post: 07-22-2015, 07:16 AM
  3. Replies: 6
    Last Post: 01-07-2014, 03:24 PM
  4. Replies: 1
    Last Post: 09-30-2013, 09:52 AM
  5. Replies: 0
    Last Post: 08-04-2011, 07:27 AM
  6. [SOLVED] Get pivot table to show row label if no data is there
    By bugmenot in forum Excel General
    Replies: 0
    Last Post: 07-28-2009, 05:47 PM
  7. [SOLVED] Calculate and display individual error bars for individual points
    By del in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-30-2006, 11:30 PM

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