Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart Help
Good day.
I would like to make a chart with the following data below. Lbs_FT for my X axis and the R1, 2 , 3 to be plotted on a line chart. How do I do this. My X Axis only shows 1 - the number of rows? Any help would be appreciated. lbs_ft r1 r2 r3 0.14246848 218.8 1267.92 808.66 0.1754445 269.5 1318.57 859.31 0.23822722 320.2 1238.13 836.27 0.2697695 349.6 1234.79 847.29 0.37028222 426.6 1213.38 868.93 0.4799795 449.3 1088.55 808.68 0.211288 284.0 1201.92 800.07 0.3640945 402.0 1155.99 825.90 0.50233722 458.1 1081.03 808.34 0.6551545 534.6 1091.93 847.95 0.8384145 523.2 949.36 762.79 1.04694282 603.0 996.45 824.22 0.875875 420.4 748.26 604.74 1.41707412 605.4 897.15 769.42 1.56898588 602.5 864.76 749.95 1.57554367 605.0 867.28 752.46 2.327625951 502.8 650.30 585.71 3.6330855 523.2 621.52 578.46 4.780285352 596.6 681.82 644.50 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart Help
Make an XY chart. Line charts do not recognize numerical values.
http://peltiertech.com/WordPress/200...-vs-xy-charts/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "K" wrote in message ... Good day. I would like to make a chart with the following data below. Lbs_FT for my X axis and the R1, 2 , 3 to be plotted on a line chart. How do I do this. My X Axis only shows 1 - the number of rows? Any help would be appreciated. lbs_ft r1 r2 r3 0.14246848 218.8 1267.92 808.66 0.1754445 269.5 1318.57 859.31 0.23822722 320.2 1238.13 836.27 0.2697695 349.6 1234.79 847.29 0.37028222 426.6 1213.38 868.93 0.4799795 449.3 1088.55 808.68 0.211288 284.0 1201.92 800.07 0.3640945 402.0 1155.99 825.90 0.50233722 458.1 1081.03 808.34 0.6551545 534.6 1091.93 847.95 0.8384145 523.2 949.36 762.79 1.04694282 603.0 996.45 824.22 0.875875 420.4 748.26 604.74 1.41707412 605.4 897.15 769.42 1.56898588 602.5 864.76 749.95 1.57554367 605.0 867.28 752.46 2.327625951 502.8 650.30 585.71 3.6330855 523.2 621.52 578.46 4.780285352 596.6 681.82 644.50 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart Help
Hi Jon, I apreciate your time. I got it to work though. I actually had to set
up my data into rows not cloumns. What I did was select all of the Data including headings. Then delete the first row which would be Tube(Lbs/ft) heading from the Series and then select the first row Tube(Lbs/ft) data as my X values. Worked perfectly. Tube (Lbs/ft 0.142 0.175 0.211 Furnace load (Lbs/hr) 218.8 269.5 284.0 ( tube +.5" sled) 1267.92 1318.57 1201.92 ( tube + .375" sled) 808.66 859.31 800.07 "Jon Peltier" wrote: Make an XY chart. Line charts do not recognize numerical values. http://peltiertech.com/WordPress/200...-vs-xy-charts/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "K" wrote in message ... Good day. I would like to make a chart with the following data below. Lbs_FT for my X axis and the R1, 2 , 3 to be plotted on a line chart. How do I do this. My X Axis only shows 1 - the number of rows? Any help would be appreciated. lbs_ft r1 r2 r3 0.14246848 218.8 1267.92 808.66 0.1754445 269.5 1318.57 859.31 0.23822722 320.2 1238.13 836.27 0.2697695 349.6 1234.79 847.29 0.37028222 426.6 1213.38 868.93 0.4799795 449.3 1088.55 808.68 0.211288 284.0 1201.92 800.07 0.3640945 402.0 1155.99 825.90 0.50233722 458.1 1081.03 808.34 0.6551545 534.6 1091.93 847.95 0.8384145 523.2 949.36 762.79 1.04694282 603.0 996.45 824.22 0.875875 420.4 748.26 604.74 1.41707412 605.4 897.15 769.42 1.56898588 602.5 864.76 749.95 1.57554367 605.0 867.28 752.46 2.327625951 502.8 650.30 585.71 3.6330855 523.2 621.52 578.46 4.780285352 596.6 681.82 644.50 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change bar to line in line-column on 2 axes chart in Excel2 | Charts and Charting in Excel | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) |