Hi ladies and gents,
I am familiar with changing the colours of a pie chart, however am using a Bar of Pie for the first time and don't seem to be able to change the colour of the slice that leads out to the bar. Can anyone help please?
The site wont let me add an attachment, apologies.
Last edited by jdredz_7; 06-19-2018 at 06:55 PM. Reason: Error in post
From what i remember of Excel 2010
if you want to change the color of a slice
click on the slice then click on it again
then right click it
there should be an option on the drop down that says format Data POINT
then you go to fill and then the rest should be self explanatory
Solid fill...select color etc
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I wish it were that simply - the usual process (described) works for all slices EXCEPT the slice that has been pulled out into the bar.
I wish it were that simply - the usual process (described) works for all slices EXCEPT the slice that has been pulled out into the bar.
I wish I could get image/attachment to save to show you what I mean.
hmm same principle works for the bar as well?
wasn't aware that they limited posting attachments for new users
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
I was able to get around it with a crude way. Follow this.
1. click on the pie chart and go to the fill option.
2. select solid fill and select the color that you want to appear on the slice that leads to the bar.
3. select other pies or the bars and change their color as per your need. the slice will retain its color.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks