Graphs
On the other hand, this type of graph details the status of the project according to different variables, country, domains...
I have some doubts:
- With these different graphs, can Workiva represent different values differentiated by colours in a single bar?
- Is there a possibility to create project statuses according to traffic icons? If so, would you be so kind as to let me know?
-
Hi Marta!
Welcome to the community. Thanks for your questions. Happy to help here as best I can.
The good news on your first two graphs is that stacked columns or bars are possible today in Workiva. For example, I mocked this up to be somewhat similar to your first chart example.
For this question, with these different graphs, can Workiva represent different values differentiated by colours in a single bar, yes, you can, though you'd likely have to create two stacked bar graphs and have them next to each so the range would appear the same, i.e. the projects bar, event hough it equals less than deliverables, is the same width horizontally. Below is an example of two charts to show the values but do let me know if you have questions here.
For the last question, is there a possibility to create project statuses according to traffic icons? If so, would you be so kind as to let me know? The only way I could think of showing this would be using an IF statement that either has conditional formatting to color a cell, or pulls a cells reference where the cell contains a so called traffic icon. Here's some examples.
The top 3 cells that colored have a conditional format applied if the value linked to it says green, yellow or red, and that will change how the cells is displayed. Here's the condition:
The bottom 3 cells are an if statement that references cells where I pasted in emoticons of colored circled. This is because a formula won't pull in the color of a formatted value. You can hide these after you add them, but here's the formula I'm using as example:
=IF(B5="green",$C$7,IF(B5="yellow",C5,$C$6))
I've seen these methods used to make an automated icon change in a table or Spreadsheet. Let me know what questions you have on the above, or if I've totally missed the mark as well.
Thanks again and have a great rest of your day!
1
This is awesome! Well explained with perfect examples. Thanks, Mike!
0
Commenti
3 commenti