+ Reply to Thread
Results 1 to 3 of 3

Needle position on Speedometer Graph that uses 300 degrees vice 180 degrees.

  1. #1
    Registered User
    Join Date
    05-03-2013
    Location
    Stafford, VA
    MS-Off Ver
    Excel 2013
    Posts
    2

    Post Needle position on Speedometer Graph that uses 300 degrees vice 180 degrees.

    I have my other speedometer graphs that are 180 degrees working fine, however the boss is looking for one that looks like a tachometer. I have my layout done just fine with the doughnut graph but I'm having a hard time with getting the needle from the pie chart to work the entire way around the 300 degrees. File is attached and I'm hoping someone can help. Thanks in advance.

    Royce
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Needle position on Speedometer Graph that uses 300 degrees vice 180 degrees.

    You need to modify the formula that calculates the slice from start to needle.
    Also you need to adjust the static starting slice, that was 180.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-03-2013
    Location
    Stafford, VA
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Needle position on Speedometer Graph that uses 300 degrees vice 180 degrees.

    Thanks Andy, that worked out great, the boss loves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1