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
Bookmarks