Now lets generate our (to be dynamic) data series for doughnut chart. Here is the setup:Ĭell A17 – Reserved for form control (set it to 1 manually for now)Ĭell B17 – Dynamic month name (formula: =CHOOSE($A$17 C3 D3 E3 F3 G3 H3 I3 J3 K3 元 M3 N3) ) I’ve made a series for this purpose on rows 16 and 17. Here is how our data looks:įor doughnut chart we need a simple series of data that includes one value per customer for a month. Finished product will look like the picture above.įor this interactive chart we will use a table representing monthly sales values for our top 10 customers on monthly basis as base data. ![]() Idea is, when we click on one of the spin buttons chart show data for previous or next month, depending on the arrow direction you clicked. ![]() For this example, we are going to make a doughnut chart and add some interactivity using a spin button.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |