Forum Discussion
Overlaying a Line Value on a Chart
John_G where exactly are you stuck?
Ok you want the line to represent the subcontract value.
I see 8 bars - what do they represent - and how do you calculate the value of each bar?
The sample data table you've posted is not enough to duplicate the chart?
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?