Here's what I'm trying to do, I have 5 points that I would like to plot on a chart and connect with a line. I think the XY Scatter chart is my best choice.
For Example, I'd like to plot the following points that are stored in a table:
1200 lbs, 31.5"
1280 lbs, 31.5"
1600 lbs, 32.9"
1600 lbs, 36.75"
1200 lbs, 36.75"
My X Axis would be inches and range from 31 to 37. The Y Axis would be pounds from 1200 to 1650.
I'd like to be able to plot these points in a pivot chart. I also have a point that is calculated on different variables that is in a pounds, inches format that I would like to plot separate from the above. I have an example in excel if I'm not clear enough on explaining what I would like to do.
Thanks for the information in advance!
For Example, I'd like to plot the following points that are stored in a table:
1200 lbs, 31.5"
1280 lbs, 31.5"
1600 lbs, 32.9"
1600 lbs, 36.75"
1200 lbs, 36.75"
My X Axis would be inches and range from 31 to 37. The Y Axis would be pounds from 1200 to 1650.
I'd like to be able to plot these points in a pivot chart. I also have a point that is calculated on different variables that is in a pounds, inches format that I would like to plot separate from the above. I have an example in excel if I'm not clear enough on explaining what I would like to do.
Thanks for the information in advance!
