Not in a chart, and, automatically, only in 3 colors maximum.Excel's conditional formatting will do it automatically...
Not in a chart, and, automatically, only in 3 colors maximum.Excel's conditional formatting will do it automatically...
Not in a chart, and, automatically, only in 3 colors maximum.
No worriesOops, sorry, saw your post after I posted, should have deferred to the experts. I am doing it but using some Python code a friend wrote, was confused.
While this would indeed work, it's limited to 3 ranges, whereas you proposed 5, and "the simple version" is for line charts. A bar chart would necessitate more complex data management on @amirm's end. The sample file I created needs just the device name and the SINAD value in 1 row per device.https://www.myonlinetraininghub.com/excel-multi-colored-line-charts
This explains how to use multi-color gradients on charts so it automatically varies color depending upon the value charted. This should be easy to do and automatic. I think as someone mentioned it is limited to 3 colors that blend together somewhat, but it should be useful.
Oh no, no, no. It actually easier to be confused with 0.000x%. I remember that absolute human hearing range is 120dB, but I need to calculate how much zeros there should be in percentage.The formatting is better, but I would still get rid of it. Or at least replace it with the equivalent THD+N at 1kHz measurement. How many people actually realize that the difference between -115 and -105 is actually just .00056% vs .00018%? -95 is still only .002% THD+N. Objectivists tend to get caught up in these sorts of simplistic things, which allows the subjectivists to malign and laugh at them for stuff like this, and probably fairly so.
That's not to diminish the value of the underlying testing, but I don't particularly like a single metric which tells you nearly nothing useful, but which people probably assume does. I would put a huge disclaimer on it that virtually ALL of the products on the chart are completely transparent in terms of THD+N at 2V at 1kHz, and that you need to look at more detailed testing to be able to learn anything meaningful. Okay, enough party pooping. The reformatting is much better.
I had seen that and implemented it today. It is not good. It creates three lines for each row with only one visible. Problem is that the bar graph becomes 1/3 as thin which is a no go.Not fully automatic, but it comes close to it: a tutorial here
I had seen that and implemented it today. It is not good. It creates three lines for each row with only one visible. Problem is that the bar graph becomes 1/3 as thin which is a no go.
What makes this is a pain is that you can't multiselect bar graph lines either to set their color.
Can't believe there is no such feature here natively.
What makes this is a pain is that you can't multiselect bar graph lines either to set their color.
Well for now why not implement the 3 color gradient. While not 5 categories I had in mind, it is very easy to do. And gets us part way there.I had seen that and implemented it today. It is not good. It creates three lines for each row with only one visible. Problem is that the bar graph becomes 1/3 as thin which is a no go.
What makes this is a pain is that you can't multiselect bar graph lines either to set their color.
Can't believe there is no such feature here natively.
...use Python to import...
I can't because in all the reviews I have mentioned the four quarters.Well for now why not implement the 3 color gradient. While not 5 categories I had in mind, it is very easy to do. And gets us part way there.
Oh no, no, no. It actually easier to be confused with 0.000x%. I remember that absolute human hearing range is 120dB, but I need to calculate how much zeros there should be in percentage.