Hi,
I am creating pivot tables and using a colour theme for each different one (as I have a number of different categories of data and want to make them distinct). However, there are only so many preset styles with only 7 different colours. I need to use one of the preset styles but apply a new colour to it. Is this possible without having to create a new template from scratch?
Thanks
MissDB
You may duplicate style (right click it) and then modify its colours.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Hi,
Thank you but you still have to pick out all the indivudal secitons of the table and amend the colours individually
Thanks
MissDB
I understand now. I do not think there is easy solution for this. It maybe possible with VBA - I have not tried this before.
Here is code which may help - you must format one range of cells with colours you wish to use as base colour for new styles and update code to use this range, also you must change to use which built-in pivot style you wish to use as base:
Please Login or Register to view this content.
Thank you very much but unforatunely I have to avoid using code in this spreadhseet as I need other colleagues to be able to use it.
I will look at another solution.
Many thanks
MissDB
This code is only to create styles - it does not have to remain in the workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks