In reply to Assaf Levi. Hi Assaf - When you use the MouseDown or MouseUp events, you can identify which point w...
https://peltiertech.com/chart-events-microsoft-excel/#comment-1575899
In reply to Bao Duong. Hi Bao - There are two possible solutions to this. One approach is to keep the workb...
https://peltiertech.com/remotely-trigger-excel-vba-macro/#comment-1575897
Hi Jon, Late on this post, but I wish I was back in my QA role from many years ago. This functionality would have made my life so much simpler. I attended the Meetup launch and was impressed with...
https://peltiertech.com/pbcharts-inflation-analysis/#comment-1575893
There is a detailed, step-by-step tutorial about this called Diverging Stacked Bar Charts.
https://peltiertech.com/diverging-stacked-bar-charts/#comment-1575889
That's a good solution. However, this solution is kind of "pull" solution which macro pulling the file to check for the update. If there would be a "push" solution (it's like a listener socket to...
https://peltiertech.com/remotely-trigger-excel-vba-macro/#comment-1575869
Hi Jon, First of all, thanks for the incredibly useful tutorial. I would like to take an action directly when clicking a specific point within a chart series. Due to the way Excel charts work, th...
https://peltiertech.com/chart-events-microsoft-excel/#comment-1575751
In reply to Traci Abbey. Hi Traci - You cannot make this chart as a pivot chart, since it has...
https://peltiertech.com/revenue-chart-showing-year-over-year-variances/#comment-1575462
This is amazing! I was wondering if you could figure out how to get it to work with a pivot table/slicer. It works when I first create it, but once I save it, close it, and re-open it I start los...
https://peltiertech.com/revenue-chart-showing-year-over-year-variances/#comment-1575403
In reply to Jon Peltier. Chase sent me his workbook, and I discovered an issue with one of the seri...
https://peltiertech.com/trendline-calculator-for-multiple-series/#comment-1575185
In reply to Chase. Chase - I just tried this; my chart has 14 series, and I chose four of them to i...
https://peltiertech.com/trendline-calculator-for-multiple-series/#comment-1575183