Hello All
Please see attached
I would like a 2nd graph showing (Pie Chart) showing % of sales for each customer
I would like this on 1 Tab so they both update as more data is fed into the sheet
Thanks for your time
Hello All
Please see attached
I would like a 2nd graph showing (Pie Chart) showing % of sales for each customer
I would like this on 1 Tab so they both update as more data is fed into the sheet
Thanks for your time
If I understand correctly then one simple way to accomplish the goal is to produce a second pivot table from the source data.
The second pivot table utilizes Customer in the Rows field and Total Cost in the Values field.
The Week and Month slicers are connected to both pivot tables/charts.
Note that this is modeled on the Pivot2 sheet.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
How do you connect the Slicer to both Pivots
Also, When i change the font size it keeps automatically changes it back
Here is a tutorial about connecting slicers to multiple pivot tables: https://contexturesblog.com/archives...-2010-slicers/
The following tutorial may help with font size pertaining to data labels: https://peltiertech.com/?s=set+defau...ze+data+labels
You might also search the Peltiertech.com site to find more information.
Alternatively, you might mark this thread as 'Solved' and open a new thread on the topic of data label size so that it will attract some of the contributors that knowledgeable on that specific subject.
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks