robertino Posted October 29, 2020 Share Posted October 29, 2020 Hi guys, I'm using data visualization to color my lighting devices on my plot, I try to have the same symbols color on my worksheet but there is no way! I'm trying to export my worksheet to an excel file but the symbols thumbnails are no supported.......which is the simplest way to do this? thx Quote Link to comment
A.D.K. Posted November 1, 2020 Share Posted November 1, 2020 I don’t know if this would work for you, but I just colour the symbols instead of using a data visualization. that does mean you’re tied to that look (unless you change it on a case by case basis), but maybe helpful? Quote Link to comment
Alexey Trebukhin Posted November 5, 2020 Share Posted November 5, 2020 @robertino hi! Is this what you are looking for? If If yes, use: =IMAGEBYDATAVIS('data visualization name') in first column. 3 1 Quote Link to comment
robertino Posted November 5, 2020 Author Share Posted November 5, 2020 1 hour ago, Alexey Trebukhin said: @robertino hi! Is this what you are looking for? If If yes, use: =IMAGEBYDATAVIS('data visualization name') in first column. THANK YOU MAN.....IT IS EXACTLY THAT I'M LOOKING FOR!!!!! 1 Quote Link to comment
Mark Aceto Posted October 11, 2021 Share Posted October 11, 2021 On 11/5/2020 at 10:16 AM, Alexey Trebukhin said: If yes, use: =IMAGEBYDATAVIS('data visualization name') in first column. Just out of curiosity, how long has =IMAGEBYDATAVIS('data visualization name') been in there/available? 1 Quote Link to comment
MartinBlomberg Posted June 19, 2023 Share Posted June 19, 2023 Hi Is there a way to use DataVis to mark an entire row in a worksheet with a specific color? Say for instance that I have two different objects, "A" and "B", where A=Red and B=Blue as per DataVis. If I want a list of all object in a worksheet where all the rows have the DataVis settings to them. So "A" have red background in the worksheet, and B has blue. Make sense? Thanks! Quote Link to comment
Pat Stanford Posted June 19, 2023 Share Posted June 19, 2023 Worksheet database subrows take their attributes from the header row. There is no way to change the color/font/style for a single row. The exception is and Image because that will be different for each object and can be set using the object properties of a Data Visualization. 1 Quote Link to comment
MartinBlomberg Posted June 19, 2023 Share Posted June 19, 2023 Ok thanks @Pat Stanford for the info. I'll figure out another way to make my worksheets clearer 😃 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.