Tag Archives: Form Controls

(Kind of) Paginated report in #Excel

Posted on October 14, 2023 by MF

A picture tells a thousand words. This is what we want to achieve. It is only “kind of” a paginated report because it works only on the application (Excel) but not for printing. 😅 With dynamic array and new functions … Continue reading →

Rate this:

Posted in Excel in Action | Tagged , , , | Leave a comment

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

The basic of Form Controls

Posted on June 24, 2017 by MF

Want to work like an Excel Pro?  Learn more about Form Controls. Have you seen someone using Check box, Option Buttons, Scroll Bars on their worksheets and be impressed?  You may wonder how they made it and think that is … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 6 Comments

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

Want some pies?

Posted on February 25, 2017 by MF

First of all, this blogpost is about Pie Chart, but not about how to make a Pie Chart.  Indeed, I am not going to show the steps of making Pie Chart here.   Also I am not intended to discuss whether … Continue reading →

Rate this:

Posted in Chart | Tagged , , | 2 Comments

Merry Christmas

Posted on December 24, 2016 by MF

Dear readers, Merry Christmas!!! Wishing you and your family a healthy, fruitful, rewarding and Happy New Year of 2017! See you next year! p.s.  Should you want to play around the Excel Card above,  here’s the christmas-tree! Tip: Hold F9 for … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment