• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results for query: SPEEDOMETER CHART

  1. AlanSidman

    Best Chart for the data I have

    Maybe a speedometer chart
  2. E

    Speedometer chart

    hmm.. i'm newbie. My 1st time doing excel dashboard with chart like this. i don't seemed to figure out after browsing all the speedometer chart questions and answers in this forum...
  3. V

    Speedometer chart

    eggMuffin Did You search as I gave a hint (#2 reply)? ... I even found one of mine: https://chandoo.org/forum/threads/speedometer-chart-with-4-sectors.45105/ There could be more speedometers. ... that's why, in Forum Rules is that sentence ~hint.
  4. Chihiro

    Speedometer chart

    Personally, I think gauge/speedometer chart is poor way to visualize data and much prefer bullet chart for target comparison. Have a read of link below. Best Charts to Compare Actual values with Targets (or Budgets) - Charting Options for Excel (chandoo.org) As for your question... your needle...
  5. E

    Speedometer chart

    Hi, Apologized for not sending any attachment. I need to create speedometer chart or guage based on the score %. I have created a chart following youtube but the needle did not move to the right place. Some of the scores are over 100% and i do not know how to create such chart. need expert...
  6. E

    Speedometer chart

    ...0% to 100%. But i have different types of charts to create due to the range of KPI metrics is different. e.g How to create a speedometer chart if my KPI metrics range not within 0% to 100%? example like this.. Need help. Max Target Yellow Red 100% 98% 96% 95% Green Yellow...
  7. P

    Speedometer Chart with 4 sectors

    Hi Chandoo colleagues. For some time now we’ve been using a 3-sector Speedometer chart in our monthly presentations to management (please see attached spreadsheet). The three sectors each represent progress (between 0% and 100%) of unrelated stages of a larger process. This works well...
  8. J

    Dashboard/chart

    Hi, Hui made me a nice speedometer chart. The chart is in the Foglio 1 tab and I would like it to be in the Dashboard tab. Can you show me how to move that chart over to the dashboard tab? Also, I added a player to chart but doesn't seem to be appearing in the chart. I refreshed the data...
  9. J

    Speedometer Chart

    ...previous help on my other projects. You have been very helpful and I appreciate your prompt response. I was looking to create a speedometer chart for my dashboard tab involving the name of the player: goals, assists and goals. I would like to have one of each for goals, assists, and...
  10. P

    Speedometer with multiple needles

    I'm trying to create a speedometer chart using Doughnut and Pie charts. I've got a doughnut that shows red, yellow and green performance ranges. I'm able to use a pie chart to show a needle indicating performance. I need to show 3 needles: beginning, previous period, and current performance...
  11. T

    Pointer in Speedometer Chart

    Respected Sir, We have a speedometer chart displaying the below values- Actual - 126 Target- 2043 The pointer is not getting aligned with the value for actuals. Kindly let me know how to get this aligned. Thanks, with regards, thomas
  12. Hui

    Stack Data show in graphical way

    Normally for Stacked or Cumulative data I would recommend a Stacked Column Chart But if you really want you could use a Speedo chart with 2 needles Refer: http://forum.chandoo.org/threads/multiple-pointers-gauges-in-speedometer.24009/
  13. Wilco()

    Gauge and NPS

    I am trying to create a gauge (http://chandoo.org/wp/2008/09/09/excel-speedometer-chart-download/). Which seems to go okay. My challenge is to create a gauge for NPS score. This is a value between -100 and 100. What is the correct value for the table "blank area"?
  14. S

    Speedometer chart

    Dear All, With reference to the attachment, I could not get proper Speedo meter chart/Gauge chart when I put needle chart over the donut chat, like the side one. Why?
  15. N

    Multiple Pointers/Gauges in Speedometer....

    Hi, Any one can help me creating in "Multiple Pointers/Gauges in Speedometer...." chart please don't forget to revert to my mail id too regards Nag.B nagireddybaireddy@gmail.com
  16. bobhc

    Speedometer Graph Help

    Might be hard to believe but search function top right does work. http://chandoo.org/forum/search/1367346/?q=SPEEDOMETER+CHART&o=date .
  17. K

    Speedometer Graph Help

    Morning all, My boss has challenged me to represent data in a new way, above and beyond the typical bar chart set up - he's suggested doing a speedometer but I'm stuck with the how? Any basics/ tips would be greatly appreciated.
  18. I

    SPEEDOMETER OUT OF THE DRAWING

    ...everybody, please ignore previous comments, I just need additional help regarding this attached file. So I have found this cool speedometer chart. Does anyone of you Excel gurus know if its possible to add below cells to dynamically set the max value, and the pointer to respond to new...
  19. N

    How To Modify This Formula To Change The Chart Bar Colours

    ...tab should be coloured this same colour ; is this correct ? This same action should be taken for every project. 2. For the speedometer charts , you have displayed a legend at the bottom of the dashboard , indicating the colours for Planned , Active , Delayed , Stopped and Completed. Is...
  20. Hui

    Speedometer on Excel

    Keerati Firstly, Welcome to the Chandoo.org Forums Have you read the following post ? http://chandoo.org/wp/2008/09/09/excel-speedometer-chart-download/ One of the tips/secrets to dashboards is that you have to remember that Pies/donuts require data for the full 360 deg of the circle So if...
  21. Hui

    Display Speedometer. | After selecting emp name from dropdown.

    Pls read: http://chandoo.org/wp/2008/09/09/excel-speedometer-chart-download/
  22. Nitesh Khot

    Display Speedometer. | After selecting emp name from dropdown.

    Respected Sir, Absolutely right...But I want speedometer like :- Please update me i want same like above spedometer.
  23. Nitesh Khot

    Display Speedometer. | After selecting emp name from dropdown.

    Hi.. I have attached file of some emp data . I want if I select empname from dropdown list then chart display speedometer and heading should display emp name & amount. Kindly help and also give the steps to how to create the same.
  24. D

    Speedometer chart problem: Aligning pie chart with doughnut chart.

    I am experimenting with a speedometer chart once more. I have a doughnut chart with values ranging from 0 thru 100 to form the upper half of the dial/gauge. I have created a pie chart with a needle showing in black. All other slices have been set to a transparent background fill. I am having...
  25. D

    Values of slices on pie chart for gauges

    I'm working on gauges here. http://chandoo.org/wp/2008/09/09/excel-speedometer-chart-download/ I downloaded the Excel file for the dial chart. I shaded the slices on the pie chart to "see" everything. I changed the gauge value to 68. The second largest slice and the slice for the needle are...
Back
Top