I have a Doughnut chart !!!
And I want to divide it equally spaced (but Variable) slices
If I have to divide it in 24, I have created a Column 1 to 24 with value 10 in
So I have added a Series, selecting that range
But I want to update that to 48 slices, or 96
How to define it ?
Last edited by AliGW; 02-24-2019 at 01:48 AM.
What you need is to drive the chart using a named dynamic range.
I created a range called NumParts =OFFSET(Sheet1!$A$3,0,0,Sheet1!$B$1,1) and used this as the source of the series data.
Here are two wikis that explain how to make named dynamic ranges and how to use them in charts.
http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges
http://www.utteraccess.com/wiki/Dynamic_Charting
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
I did what you said, created that NumParts
Then created a Series with it
But when I change B1, chart will not update
I believe that the attached demonstrates dflak's proposal.
Notice that if you open the Select Data Source dialog box and then select to edit "nr" the Series Values window reads: ='question (ionelz).xlsx'!NumParts
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.
Thank you so much, I got it !
Is possible to define dynamic numbers for Series !?
So to add dynamic rings to doughnut !
Apparently I forgot to attach the spreadsheet.
Thank you so much
B2 - control the number of Slices
But now I have C2 which should control number of Rings
How to define that, variable number of rings ?
I am not too sure what the objective is here but I got something that works with VBA. It still uses named ranges. I haven't figured out a way to make the range reference itself multiple times.
I am sure that somebody will come up with a method to add and / or delete series to the chart. That's a lot more coding than I'm willing to do.
With this model, you will need a column for every ring you want.
Objective is this :
To create a Variable number of doughnut SLICES (this is done, thank you)
And variable number of doughnut RINGS
If Slices=100 I have 8 Rings
If Slices =70 , I have 6 rings
So I need to variate rings too, otherwise i have to create max of them
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks