Pivot Table - Data Bars [SOLVED]

[ianb]

Hi,


I have various pivot tables that a user can interact with.


I would like to show data bars the start of a refresh of the pivot table and also when the pivot table is changed.


At present I am selecting conditional formatting - data basrs yet when I change the pivot table the data bar disapears.


Any ideas !!!!???


Thanks.

 

[ianb]

Hmm.. Tried it again and it has worked.


FOr some reason it was not saving the conditional formatting as a pivot change !!!

 

[ianb]

Any tutorial would be welcomed. Thank you...

 

[ianb]

All you need to know. Solved. thanks.


http://peltiertech.com/WordPress/sparklines-and-data-bars-in-excel-2010/


http://www.contextures.com/excel-conditional-formatting-data-bars.html