[Affiliate]
Blog Stats
- 3,190,945 hits
-
Join 3,265 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Open an embedded Excel file during a slide show in PowerPoint?
- Highlight weekends and holidays using Conditional Formatting in #Excel
- Append tables with inconsistent column names with #Excel #PowerQuery
- Transform and Combine all worksheets in an #Excel workbook with #PowerQuery
- Send a cell content to Google search
- Calculating CAGR with Goal Seek in #Excel
- CTRL A to Z - Learn 25 #Excel Shortcuts with demonstrations
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Form Controls
(Kind of) Paginated report in #Excel
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
Interactive Chart is not difficult to make – Part 3/3
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
Interactive Chart is not difficult to make – Part 2/3
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
Interactive Chart is not difficult to make – Part 1/3
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
Posted in Chart, Excel Tips
Tagged Form Controls, IF, Interactive chart, Option Button
Leave a comment
The basic of Form Controls
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
Interactive Chart with navigation panel [NO VBA]
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
Posted in Chart
Tagged Conditional Formatting, Form Controls, INDEX, Interactive chart, Linked Picture, ROW
3 Comments
Want some pies?
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
Merry Christmas
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
wmfexcel 