Forum Discussion
Overlaying a Line Value on a Chart
Hello - I have a data table that looks like this, and I am trying to make a bar chart that displays the subcontract value as a 'line value' (see second pic as an example of what I am trying to achieve)
So I have many different issue descriptions per company, many companies per project, and a single subcontract value for each company on each project.
I'm stuck! Can anyone help me on this?
5 Replies
Sean Hi - Yes I know the data set I posted is just an example and does not match the graph I posted.
Yes, I want the line to represent the contact value at each project.
Each bar represents a project, and a count of how many issues are noted for a particular subtrade on the project.
The problem is, each issue on a project has the same 'subcontract value'
For example:
Trade A | Project 1 | Missing plug | Subcontract value $100,000
Trade A | Project 1 | Missing switch | Subcontract value $100,000
Trade A | Project 1 | Missing thermostat | Subcontract value $100,000
If I graph this, I get a line that says either "3" or "$3,000,000" but what I really need is a line that says "$100,000"
Make sense?
