column graphs with lines

sweetie · Apr 19th, 2002, 06:44 AM

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.

smittycft99 · Apr 19th, 2002, 12:44 PM

If you create the entire chart as column type (including percentages) finish the chart and right click on the percentages columns and change chart type to line

Hope this helps

sweetie · Apr 19th, 2002, 01:06 PM

I am specifying what data columns to grab for the chart and its grabbing extra data columns and don't know why (no apparent reason and incorporating them into the graph.
How do we stop it from grabbing the extra data? Also the percentages are too tiny to show up on the grap how do I click on them to change it.
thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 06:44 AM	#1
sweetie New Member Join Date: Apr 2002 Posts: 5	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.

Apr 19th, 2002, 12:44 PM	#2
smittycft99 Board Regular Join Date: Apr 2002 Posts: 130	If you create the entire chart as column type (including percentages) finish the chart and right click on the percentages columns and change chart type to line Hope this helps

Apr 19th, 2002, 01:06 PM	#3
sweetie New Member Join Date: Apr 2002 Posts: 5	I am specifying what data columns to grab for the chart and its grabbing extra data columns and don't know why (no apparent reason and incorporating them into the graph. How do we stop it from grabbing the extra data? Also the percentages are too tiny to show up on the grap how do I click on them to change it. thanks.