Been using Excel for 20+ years, but my company was bought out and now we have to use Gsuite. It has not been fun. My biggest problem is the seemingly limited charting capabilities. Say I have the below table
I need to make a ton of charts out of this data. I can make a chart of all SUT1 testcases or all config1 testcases, but I cannot figure out how to make a chart like:
config1:sut1
config2:sut2
config3:sut3
This is easy to do in excel, I just click the cells I want. AFAICT google sheets on lets you create charts of contiguous cells. How to do it in Gsuite?
| TestCase | SUT1 | SUT2 | SUT3 |
| Config1 | 58% | 25% | 34% |
| Config2 | 75% | 35% | 55% |
| Config3 | 85% | 67% | 67% |
I need to make a ton of charts out of this data. I can make a chart of all SUT1 testcases or all config1 testcases, but I cannot figure out how to make a chart like:
config1:sut1
config2:sut2
config3:sut3
This is easy to do in excel, I just click the cells I want. AFAICT google sheets on lets you create charts of contiguous cells. How to do it in Gsuite?
Last edited:
Facebook
Twitter