I need to create a graph that consists of column graphs along with 4 lines. The data will be the column graph and the lines should be a straight line indicating the the percentage factor. There are 4 different percentages (cost growth factors). There are a total of 10 columns of data. The first 2 columns are the name of the projects and work order numbers which shows down below the graph. I have 4 columns with fomulas that is the actual data and 4 columns with the percentages.
I can get the column graphs to work (with the job number and work order number under the columns), but can't get the straight lines showing the percentages. The percentages are like .030, 0.072 etc. I also seem to have trouble getting the graph range to accept all 10 columns. It also seems to leave 2 columns off the range even though it shows it has it.
thank you.
I can get the column graphs to work (with the job number and work order number under the columns), but can't get the straight lines showing the percentages. The percentages are like .030, 0.072 etc. I also seem to have trouble getting the graph range to accept all 10 columns. It also seems to leave 2 columns off the range even though it shows it has it.
thank you.