Excel Textbox Link Extra Trick
I have shared before you can link a textbox to a cell and have a customised message delivered via the textbox. But there is something else I recently learned from Wyn Hopkins (MVP) about this technique.
(more…)Hiding Zeroes in Excel
Excel has a sheet setting that allows to stop zeroes from displaying in the whole sheet. There is a simple macro line of code that makes it easy to change.
(more…)Using Colours Effectively in Excel Charts
When I reviewed the charts in the CPA Australia 2024 Annual Report I found another series of charts that could be improved.
(more…)Column vs Bar Chart in Excel
As I was reading the CPA Australia 2024 Annual Report I was interested in the presentation of charts (graphs). A lot of money had been spent on the presentation of the report. There were lots of high-quality photos and other images. I was disappointed with much of the data visualisation.
(more…)