In excel it is not easy to change a chart´s data source without manually changing the data source in chart […]

Comments(2) Filed in categories: Charts, Drop down lists, Excel, Interactive

Rudy asks in this post Use a mouse hovering technique to create an interactive chart: Is it possible to create […]

Comments(3) Filed in categories: Charts, Excel, Interactive

My fascination for charts and vba continues (see previous posts). This post demonstrates how to highlight a group of values […]

Comments(1) Filed in categories: Charts, Drop down lists, Excel, Interactive

The following animated gif shows you a sheet where you can select column (Region) or a row (Month) and the […]

Comments(4) Filed in categories: Charts, Excel, Interactive

I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]

Comments(22) Filed in categories: Charts, Excel, Interactive

I found a basic interactive chart on the chitika website and my first thought was if I could do this […]

Comments(17) Filed in categories: Charts, Excel, Interactive

The following vba code makes it possible to automatically update a chart when you click a cell in a table. […]

Comments(7) Filed in categories: Charts, Excel, Interactive

Fatou asks: Going back to my question, I had created a table and used the data to create a chart. […]

Comments(13) Filed in categories: Charts, Excel, Interactive

This blog post demonstrates how to quickly change chart data range. I have created a drop down list (form control) […]

Comments(22) Filed in categories: Charts, Drop down lists, Excel, Interactive

Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]

Comments(161) Filed in categories: Charts, Excel, Interactive