Tag Archives: Interactive chart

Interactive Chart is not difficult to make – Part 3/3

Posted on July 26, 2017 by MF

Using Option Button to display different items on chart So far, we have made an interactive chart with check box to highlight items with negative growth; with scroll bar to see more items in a confined space.  In this post, … Continue reading →

Rate this:

Posted in Chart, Excel Tips | Tagged , , | 1 Comment

Interactive Chart is not difficult to make – Part 2/3

Posted on July 22, 2017 by MF

Using Scroll Bar to show more This is an extension of the previous post – Using Checkbox to highlight negative growth in a bar chart.  In that post, we had created a chart showing top 10 items, which allowed user … Continue reading →

Rate this:

Posted in Chart, Excel Tips | Tagged , , | Leave a comment

Interactive Chart is not difficult to make – Part 1/3

Posted on July 15, 2017 by MF

Using Checkbox to highlight negative growth in a bar chart In previous post, we talked about the basic of Form Controls.  I hope you had time to practice it and found useful way of building interactivity to your spreadsheet. In … Continue reading →

Rate this:

Posted in Chart, Excel Tips | Tagged , , , | Leave a comment

Interactive Chart with navigation panel [NO VBA]

Posted on March 4, 2017 by MF

Isn’t it nice?  Don’t think that this is difficult.  No VBA is required.  Indeed you only need to know a few Excel skills in order to create an interactive chart  with navigation panel like this. The skills required: Conditional formatting … Continue reading →

Rate this:

Posted in Chart | Tagged , , , , , | 3 Comments