how to build a dashboard in numbers (re-new)
I wonder if Apple Mac's Numbers can make a simple Dashboard such as excel dashboard ( https://www.youtube.com/watch?v=6I0ocMFudwc ).
Thanks.
MacBook Pro Retina (2015 and later)
Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.
Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >
Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I wonder if Apple Mac's Numbers can make a simple Dashboard such as excel dashboard ( https://www.youtube.com/watch?v=6I0ocMFudwc ).
Thanks.
MacBook Pro Retina (2015 and later)
Here is an example of what I put together. It is only the example how to make the speedometer. IF you post a specific question I an assist in working this into a dashboard
My first thought is there may be easier ways but sometimes easier is not always better.
Here is an example of what I put together. It is only the example how to make the speedometer. IF you post a specific question I an assist in working this into a dashboard
My first thought is there may be easier ways but sometimes easier is not always better.
Charts like that are possible in Numbers, but probably more work than they are worth.
To see an example of a simple dashboard-like presentation in Numbers see the 'Running Log' template at File > New in your menu.
Though it's for running, it can be modified so it is applicable to a lot of other activities where you want to monitor KPI in a visual fashion.
SG
The speedometer chart is really cool! But if you're trying to get work done and measure how much you are getting done then sticking with the charts natively supported in Numbers might be the way to go. Lots of management dashboards use those rather than speedometers to track KPI.
SG
An aside…
Watching the video linked in the question, I was reminded of an example presented in a Psych 201 ch=lass several years ago.
The example was of the 'dashboard' of a WWII vintage aircraft consisting of 'speedometer' dials presenting data readings on several variable essential to the safe operation of the aircraft. In the initial example, all the meters had been installed with the top at the top and the bottom at the bottom, following the positioning determined by the meter's manufacturer. The revised example had the meters rotated so that all of the 'normal' readings had the needles pointing within a couple of degrees of 'straight up.'
The field test results were a significant reduction in mishaps with the aircraft fitted with the 'straight up is normal' meters, a design factor that appears not to have been taken into account with the example provided.
Makes sense,though—it is a significantly simpler task to spot the one (or two) meters NOT pointing close to straight up than to find the oddball(s) in a collection of meters pointing in several 'correct' directions.
Regards,
Barry
Hi Wayne,
I was thinking of this that you posted. Perhaps a Dropbox link?
I don't understand the trigonometry calculations, But it works for me!
Regards,
Ian.
Hi sachaullymce,
Wayne Contello has created a speedometer in Numbers. Sorry, I can't find the discussion. Let's hope that Wayne stops by to enlighten us all.
Regards,
Ian.
Here's the link...https://www.dropbox.com/s/r1n4ep1pq866xqq/SpeedometerExample.numbers?dl=0
It's early in the morning and I haven't had my coffee yet.
thanks I shall take a look on this one also.
thanks for poking the "Number's Dashboard Guru" ... 🙏🏻
Hi,
I am happy to help :-)
Ian.
I may have missed something Wayne, but why do you have two RED categories?
how to build a dashboard in numbers (re-new)