dgd1212
asked on
Creating a gage chart in Excel
I attempted to create a gage in Excel using this as a guide:
https://www.youtube.com/watch?v=f6c93-fQlCs
Got it to mostly work but the "needle" is 180 degrees out of place. Spreadsheet attached.
When value is 0 / 100 the needle placement should be just the opposite.
Thanks for any assistance.
TEST-GAGE.xlsx
https://www.youtube.com/watch?v=f6c93-fQlCs
Got it to mostly work but the "needle" is 180 degrees out of place. Spreadsheet attached.
When value is 0 / 100 the needle placement should be just the opposite.
Thanks for any assistance.
TEST-GAGE.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It isn't clear whether the needle should move clockwise or counterclockwise in response to a value in cell G2. My first post showed clockwise movement, so I added a second chart showing counterclockwise movement in the attached revision of the workbook.
TEST-GAGE-1Q28594278.xlsx
TEST-GAGE-1Q28594278.xlsx
ASKER
Sorry for the delay. needle should move clockwise. With your example, the needle doesn't move 100% across the dial when the value varies from 0-100.
Did you try the first file submitted. Please give your comments on it.
The workbook you originally posted had a range of 0 to 146. I did not change that.
If you want the chart to work over a range of 0 to 100, then you need to adjust the values in D2:D9 so they sum to 100. I did this for you in the attached workbook.
TEST-GAGE-1Q28594278.xlsx
If you want the chart to work over a range of 0 to 100, then you need to adjust the values in D2:D9 so they sum to 100. I did this for you in the attached workbook.
TEST-GAGE-1Q28594278.xlsx
In the original question, the desired chart shows a needle and a 214 degree range on the chart scale. ssaqibh's Comment #a40542283 shows a black area instead of the needle and changes the chart scale to 180 degrees. It responds 0 to 100 with full scale over the 180 degree chart range, but does not tell the Asker what was wrong with the original chart.
byundt Comment #a40542284 showed the Asker's chart (with 214 degree range) with a needle positioned within that range. An explanation was offered for how to properly position the needle starting point. The Asker then noted that the chart needed to respond with input values 0 to 100 representing full scale, so Comment #a40564241 described how to rescale the chart range to satisfy that requirement.
I believe that Comment #a40564241 represents the Answer, but a Split would also be acceptable.
byundt Comment #a40542284 showed the Asker's chart (with 214 degree range) with a needle positioned within that range. An explanation was offered for how to properly position the needle starting point. The Asker then noted that the chart needed to respond with input values 0 to 100 representing full scale, so Comment #a40564241 described how to rescale the chart range to satisfy that requirement.
I believe that Comment #a40564241 represents the Answer, but a Split would also be acceptable.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Do you want the needle to start with a value of 0 on the left side? If so, change the angle of the first slice from 107 to 253 degrees. See attached file.
TEST-GAGE-1Q28594278.xlsx