During last week's AKA, @excelguru.ca revisited a favorite data set: automated litter box records, where one cat caused more than 1,000 interrupted clean cycles in a single month. 🐱
In 2023, finding the culprit took serious #PowerQuery work plus manual creation of #PivotCharts linked with slicers.🧵
In 2023, finding the culprit took serious #PowerQuery work plus manual creation of #PivotCharts linked with slicers.🧵
November 2, 2026 at 5:27 PM
During last week's AKA, @excelguru.ca revisited a favorite data set: automated litter box records, where one cat caused more than 1,000 interrupted clean cycles in a single month. 🐱
In 2023, finding the culprit took serious #PowerQuery work plus manual creation of #PivotCharts linked with slicers.🧵
In 2023, finding the culprit took serious #PowerQuery work plus manual creation of #PivotCharts linked with slicers.🧵
During the course, I’ll show you how to create different types of charts, choose the best one for your purpose, and modify the chart’s appearance to make it more effective. The course will also cover PivotCharts (charts based on PivotTables) and dashboards.
Do join me!
Do join me!
October 1, 2026 at 8:45 AM
During the course, I’ll show you how to create different types of charts, choose the best one for your purpose, and modify the chart’s appearance to make it more effective. The course will also cover PivotCharts (charts based on PivotTables) and dashboards.
Do join me!
Do join me!
Not JUST Excel, but...PivotCharts!
(Which are part of Excel.)
(Which are part of Excel.)
September 28, 2026 at 11:51 AM
Not JUST Excel, but...PivotCharts!
(Which are part of Excel.)
(Which are part of Excel.)
PivotCharts built on the #DataModel are notoriously fragile when a refresh adds new series, because the chart loses track of what it's supposed to format.
I offered practical workarounds:
🟢 Layer separate combo and line charts, OR
🟢 Try driving the chart from #DynamicArrays so it works off formulas.
I offered practical workarounds:
🟢 Layer separate combo and line charts, OR
🟢 Try driving the chart from #DynamicArrays so it works off formulas.
September 28, 2026 at 5:03 PM
PivotCharts built on the #DataModel are notoriously fragile when a refresh adds new series, because the chart loses track of what it's supposed to format.
I offered practical workarounds:
🟢 Layer separate combo and line charts, OR
🟢 Try driving the chart from #DynamicArrays so it works off formulas.
I offered practical workarounds:
🟢 Layer separate combo and line charts, OR
🟢 Try driving the chart from #DynamicArrays so it works off formulas.
Unfortunately , PivotCharts built on the #DataModel are notoriously fragile when a refresh adds new series, because the chart loses track of what it's supposed to format. 😢
Ken offered practical workarounds:
You can ayer separate combo and line charts (one with a transparent background) together, OR
Ken offered practical workarounds:
You can ayer separate combo and line charts (one with a transparent background) together, OR
September 24, 2026 at 5:18 PM
Unfortunately , PivotCharts built on the #DataModel are notoriously fragile when a refresh adds new series, because the chart loses track of what it's supposed to format. 😢
Ken offered practical workarounds:
You can ayer separate combo and line charts (one with a transparent background) together, OR
Ken offered practical workarounds:
You can ayer separate combo and line charts (one with a transparent background) together, OR
I upgraded my Excel PivotTable with these 3 simple features
I upgraded my Excel PivotTable with these 3 simple features
Slicers, Timelines, and PivotCharts turned my basic PivotTable into a much more useful tool.
ift.tt
September 8, 2026 at 10:00 PM
I upgraded my Excel PivotTable with these 3 simple features
Gender is spreadsheets. Its a tool that you use for math and technology so it is man but also you only use it in office jobs so it is woman.
(PivotCharts are nonbinary bc I like them)
(PivotCharts are nonbinary bc I like them)
I have done a gender and am now in league with Pete Hegseth for not thinking AI is revolutionary for all peoples :(
August 21, 2026 at 2:56 PM
Gender is spreadsheets. Its a tool that you use for math and technology so it is man but also you only use it in office jobs so it is woman.
(PivotCharts are nonbinary bc I like them)
(PivotCharts are nonbinary bc I like them)
While it's always been possible to create a table from #PowerPivot-backed #DataModels, it has required some black magic and #DAX knowledge to make it happen. The DAX Table Monkey in our Monkey Tools #Excel add-in builds it for you with just a few clicks. 🐵 Learn more about it at mkyt.ca/daxtable.
May 13, 2026 at 4:36 PM
While it's always been possible to create a table from #PowerPivot-backed #DataModels, it has required some black magic and #DAX knowledge to make it happen. The DAX Table Monkey in our Monkey Tools #Excel add-in builds it for you with just a few clicks. 🐵 Learn more about it at mkyt.ca/daxtable.
I've found myself in the position where I've got to lead on data driven decisions on the company's data/data management.
To keep things transparent, I opted to stick to our company's official language of Microsoft Excel and PowerPoint.
Graphs and PivotCharts from CSVs loaded by Power Query.
To keep things transparent, I opted to stick to our company's official language of Microsoft Excel and PowerPoint.
Graphs and PivotCharts from CSVs loaded by Power Query.
March 6, 2026 at 8:55 AM
I've found myself in the position where I've got to lead on data driven decisions on the company's data/data management.
To keep things transparent, I opted to stick to our company's official language of Microsoft Excel and PowerPoint.
Graphs and PivotCharts from CSVs loaded by Power Query.
To keep things transparent, I opted to stick to our company's official language of Microsoft Excel and PowerPoint.
Graphs and PivotCharts from CSVs loaded by Power Query.
📊 PivotTables are powerful. But sometimes, rows and columns just don't cut it.
That’s where PivotCharts come in, helping you visualise your data clearly and instantly.
Here’s how to create and customise one in Excel: www.accountingcpd.net/Creating_a_P...
#ExcelTips #Accounting
That’s where PivotCharts come in, helping you visualise your data clearly and instantly.
Here’s how to create and customise one in Excel: www.accountingcpd.net/Creating_a_P...
#ExcelTips #Accounting
Creating a PivotChart
Learn how to create and customise PivotCharts in Excel to visualise your data clearly and build dashboards that bring your analysis to life.
www.accountingcpd.net
May 21, 2025 at 9:53 AM
📊 PivotTables are powerful. But sometimes, rows and columns just don't cut it.
That’s where PivotCharts come in, helping you visualise your data clearly and instantly.
Here’s how to create and customise one in Excel: www.accountingcpd.net/Creating_a_P...
#ExcelTips #Accounting
That’s where PivotCharts come in, helping you visualise your data clearly and instantly.
Here’s how to create and customise one in Excel: www.accountingcpd.net/Creating_a_P...
#ExcelTips #Accounting
Data Visualization & Dashboard Design: Charts, Conditional Formatting, PivotCharts, and Interactive Reporting for Decision-Makers by fru kingsly is a new release on Leanpub!
Turn analysis into action.
Link: leanpub.com/datavisualiz...
#books #ebooks #newreleases
Turn analysis into action.
Link: leanpub.com/datavisualiz...
#books #ebooks #newreleases
July 20, 2026 at 9:45 PM
Data Visualization & Dashboard Design: Charts, Conditional Formatting, PivotCharts, and Interactive Reporting for Decision-Makers by fru kingsly is a new release on Leanpub!
Turn analysis into action.
Link: leanpub.com/datavisualiz...
#books #ebooks #newreleases
Turn analysis into action.
Link: leanpub.com/datavisualiz...
#books #ebooks #newreleases
Jack-of-all-trades (see profile) post #2 -I sometimes find creating wacky Pivot Charts with ever-crashing Excel just as immersive and challenging as video games because my stubbornness kicks in. It crashed 5 times making this!
#PivotCharts #unusual #music #Spotify #playlist
#PivotCharts #unusual #music #Spotify #playlist
November 15, 2024 at 5:35 PM
Jack-of-all-trades (see profile) post #2 -I sometimes find creating wacky Pivot Charts with ever-crashing Excel just as immersive and challenging as video games because my stubbornness kicks in. It crashed 5 times making this!
#PivotCharts #unusual #music #Spotify #playlist
#PivotCharts #unusual #music #Spotify #playlist
Daten einlesen... 🙄
Aber Pivot und Pivotcharts sind top, und seit ich nur noch Google Sheets habe, vermisse ich Excel.
Aber Pivot und Pivotcharts sind top, und seit ich nur noch Google Sheets habe, vermisse ich Excel.
October 17, 2025 at 6:11 AM
Daten einlesen... 🙄
Aber Pivot und Pivotcharts sind top, und seit ich nur noch Google Sheets habe, vermisse ich Excel.
Aber Pivot und Pivotcharts sind top, und seit ich nur noch Google Sheets habe, vermisse ich Excel.
December 31, 2024 at 9:06 PM
I wanted to paint tonight, but I've just been staring at my unfinished models and well.. Nope. Sigh. Clearly, all my creativity was already poured into the PowerPoint and pivotcharts I made for work 🤭. Better luck tomorrow.
Happy weekend! 🎉
Happy weekend! 🎉
January 17, 2025 at 8:50 PM
I wanted to paint tonight, but I've just been staring at my unfinished models and well.. Nope. Sigh. Clearly, all my creativity was already poured into the PowerPoint and pivotcharts I made for work 🤭. Better luck tomorrow.
Happy weekend! 🎉
Happy weekend! 🎉
Totally agree! Power Query is the most underrated tool in the Office ecosystem. Once you load CSVs via PQ, adding new transformations (merge, unpivot, clean) is almost trivial. Tip: output to a Table (Ctrl+T) so PivotCharts auto-expand with new rows. Game changer for reporting.
March 9, 2026 at 7:14 AM
Totally agree! Power Query is the most underrated tool in the Office ecosystem. Once you load CSVs via PQ, adding new transformations (merge, unpivot, clean) is almost trivial. Tip: output to a Table (Ctrl+T) so PivotCharts auto-expand with new rows. Game changer for reporting.
Great call going with Power Query for the data pipeline. Once you have CSVs loading via PQ, adding transformations later (merging, cleaning, unpivoting) is almost trivial compared to doing it manually.
Tip: load PQ output into a Table (Ctrl+T) so PivotCharts auto-expand with new data.
Tip: load PQ output into a Table (Ctrl+T) so PivotCharts auto-expand with new data.
March 8, 2026 at 10:04 AM
Great call going with Power Query for the data pipeline. Once you have CSVs loading via PQ, adding transformations later (merging, cleaning, unpivoting) is almost trivial compared to doing it manually.
Tip: load PQ output into a Table (Ctrl+T) so PivotCharts auto-expand with new data.
Tip: load PQ output into a Table (Ctrl+T) so PivotCharts auto-expand with new data.
You decide at which stop you like what you see and stay there as long as you like.
Here's one way to think of the stops on an Excel data analysis journey:
1 - Microsoft Excel is very powerful.
With the right techniques (e.g., PivotTable and PivotCharts), it might be all the tool you need.
Here's one way to think of the stops on an Excel data analysis journey:
1 - Microsoft Excel is very powerful.
With the right techniques (e.g., PivotTable and PivotCharts), it might be all the tool you need.
April 17, 2025 at 2:36 PM
You decide at which stop you like what you see and stay there as long as you like.
Here's one way to think of the stops on an Excel data analysis journey:
1 - Microsoft Excel is very powerful.
With the right techniques (e.g., PivotTable and PivotCharts), it might be all the tool you need.
Here's one way to think of the stops on an Excel data analysis journey:
1 - Microsoft Excel is very powerful.
With the right techniques (e.g., PivotTable and PivotCharts), it might be all the tool you need.
The best way to create these visualizations is from PivotTables.
Excel's PivotCharts are one of my go-to ways to analyze data.
I mostly use PivotTables to feed my PivotCharts.
You should, too.
Excel's PivotCharts are one of my go-to ways to analyze data.
I mostly use PivotTables to feed my PivotCharts.
You should, too.
April 5, 2025 at 3:43 PM
The best way to create these visualizations is from PivotTables.
Excel's PivotCharts are one of my go-to ways to analyze data.
I mostly use PivotTables to feed my PivotCharts.
You should, too.
Excel's PivotCharts are one of my go-to ways to analyze data.
I mostly use PivotTables to feed my PivotCharts.
You should, too.
Over the years, Excel has become an exceedingly powerful data analysis tool.
For many professionals, it can be all the analytical tooling they need.
For example, Excel is a wonderful tool for visually analyzing data (e.g., PivotCharts).
For many professionals, it can be all the analytical tooling they need.
For example, Excel is a wonderful tool for visually analyzing data (e.g., PivotCharts).
March 18, 2025 at 5:47 PM
Over the years, Excel has become an exceedingly powerful data analysis tool.
For many professionals, it can be all the analytical tooling they need.
For example, Excel is a wonderful tool for visually analyzing data (e.g., PivotCharts).
For many professionals, it can be all the analytical tooling they need.
For example, Excel is a wonderful tool for visually analyzing data (e.g., PivotCharts).
2) Use more charts.
Humans are visual creatures, and we can use this to analyze data.
The best use of PivotTables is to create PivotCharts.
For example, bar charts that use three or more columns of data.
It's way more powerful than a PivotTable.
Humans are visual creatures, and we can use this to analyze data.
The best use of PivotTables is to create PivotCharts.
For example, bar charts that use three or more columns of data.
It's way more powerful than a PivotTable.
March 17, 2025 at 7:08 PM
2) Use more charts.
Humans are visual creatures, and we can use this to analyze data.
The best use of PivotTables is to create PivotCharts.
For example, bar charts that use three or more columns of data.
It's way more powerful than a PivotTable.
Humans are visual creatures, and we can use this to analyze data.
The best use of PivotTables is to create PivotCharts.
For example, bar charts that use three or more columns of data.
It's way more powerful than a PivotTable.
6) Multidimensional bar charts.
Bar charts are the go-to visual for categorical data.
But, most professionals don't create them with multiple columns.
Excel PivotCharts are great for this.
Plotnine with Python in Excel is even better.
Be sure to explore related columns and see what pops.
Bar charts are the go-to visual for categorical data.
But, most professionals don't create them with multiple columns.
Excel PivotCharts are great for this.
Plotnine with Python in Excel is even better.
Be sure to explore related columns and see what pops.
March 11, 2025 at 4:41 PM
6) Multidimensional bar charts.
Bar charts are the go-to visual for categorical data.
But, most professionals don't create them with multiple columns.
Excel PivotCharts are great for this.
Plotnine with Python in Excel is even better.
Be sure to explore related columns and see what pops.
Bar charts are the go-to visual for categorical data.
But, most professionals don't create them with multiple columns.
Excel PivotCharts are great for this.
Plotnine with Python in Excel is even better.
Be sure to explore related columns and see what pops.
5) Use multiple dimensions.
Visualizations are more powerful when you use multiple columns (dimensions) at the same time.
Excel PivotCharts can create these visualizations.
Also, Python in Excel has plotnine, the best way to make these visualizations.
Visualizations are more powerful when you use multiple columns (dimensions) at the same time.
Excel PivotCharts can create these visualizations.
Also, Python in Excel has plotnine, the best way to make these visualizations.
March 11, 2025 at 4:41 PM
5) Use multiple dimensions.
Visualizations are more powerful when you use multiple columns (dimensions) at the same time.
Excel PivotCharts can create these visualizations.
Also, Python in Excel has plotnine, the best way to make these visualizations.
Visualizations are more powerful when you use multiple columns (dimensions) at the same time.
Excel PivotCharts can create these visualizations.
Also, Python in Excel has plotnine, the best way to make these visualizations.
2) I would start with Microsoft Excel.
Here's why:
- Just about every professional has it.
- Excel supports many visualizations.
- PivotCharts are fantastic.
- Python in Excel.
Even in 2025, you can't go wrong learning to analyze data with Microsoft Excel visually.
So what to learn?
Here's why:
- Just about every professional has it.
- Excel supports many visualizations.
- PivotCharts are fantastic.
- Python in Excel.
Even in 2025, you can't go wrong learning to analyze data with Microsoft Excel visually.
So what to learn?
March 11, 2025 at 4:41 PM
2) I would start with Microsoft Excel.
Here's why:
- Just about every professional has it.
- Excel supports many visualizations.
- PivotCharts are fantastic.
- Python in Excel.
Even in 2025, you can't go wrong learning to analyze data with Microsoft Excel visually.
So what to learn?
Here's why:
- Just about every professional has it.
- Excel supports many visualizations.
- PivotCharts are fantastic.
- Python in Excel.
Even in 2025, you can't go wrong learning to analyze data with Microsoft Excel visually.
So what to learn?