Hi,
Unable to put different Category names range for both the Pies (If i change one, other also changing).
An excel file attached with sample data and chart.
Pl. help.
Thanks,
Nagesh.
Hi,
Unable to put different Category names range for both the Pies (If i change one, other also changing).
An excel file attached with sample data and chart.
Pl. help.
Thanks,
Nagesh.
Your outside chart horizontal axis label is wrong.
Multilevel pie.png
Last edited by josephteh; 05-28-2022 at 10:23 PM. Reason: Insert image
Yes. I understood but i am unable to change it.
Pl. help in changing the Horizontal axis label.
Left-mouse-click on the outer circle and the 2 ranges will be highlighted (like I did above), then pull the range in column I down and pull down from bottom-right corner to extend the range to cover I7:I11.
Tried doing that but inner circle labels are also changing (both inner and outer labels are coming same). You can try from your end in the file.
Hello
Select the Chart with the right button and, in the window that opens, select Select data and Serie 2; then in the right part of the new window select the Edit button on the right side and assign the interval I7: I11
I hope it helps.
Hello,
Mario
Last edited by Marius44; 05-30-2022 at 09:21 AM.
Replot the chart and use Value from Cells instead of Category Name for one of the circles.
Last edited by josephteh; 05-30-2022 at 09:21 AM.
Please see new post above.
Its working fine. Thanks josephteh.
Glad to be of help. Thanks for the rep. Please mark the post "Solved" if you are satisfied with the solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks