I need a gauge, similar to the one in the picture, made to work in Google Sheets (Google Docs). The one pictured here is free off the internet and works with limited abilities. I need someone that can either modify this one, or recreate one similar, allowing me to do the following.
• I must be able to cut and paste the gauge and coding so I can use it in other Google sheets.
• I must be able to work with it as a singular gauge in that if I need one gauge or 4 gauges on a sheet, I can just paste the amount I need.
• I must be able to change the ranges on each gauge individually. For instance, the one in the picture I have ranged from 0-6, but I may need one to display percentage from 0-100, so I need to be able to adjust this myself, for each gauge.
• I need control over the color ranges. The one in the picture displays Green, Orange, Red from low to high. I need to be able to changes this so that if the number 3 was the good range, I could have Red from 0-1, Yellow from 1-2.5, Green from 2.5 – 3.5, Yellow from 3.5 – 5 and Red from 5-6. Color and ranges need to be customizable by me.
• In the picture, Cell B2 is supplying the data for the needle. This is actually linked to a cell on a different page in the spreadsheet. This must still be able to work this way in that I can link this cell to another data cell.
• In the picture Cell A2 is supplying the Gauge Name. This must remain the same.