Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY Charts
On my Excel sheet I have the following:
1 st br pa 2 23.5 3 25.3 4 25.5 25 24 5 26.1 6 28.5 On one chart, would like to see points and lines as follows with the x axis 1-6 and y axis from 23 to 30 and for "st" a line from 25.3 to 25.5 to 28.5: for "br" 23.5 to 25 and for "pa" 24 to 26.1. This is a sample of height measurements for three grandsons taken a various time but not equivalent in age (above in months). When I select an XY scatter chart I get restricted to only two of the three columns. Help appreciated. Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY Charts
The way it's set up, there is no Y value for X=1. But no matter, let's
continue. If the numbers 1 thru 6 are typed into cells, you're ready to go. If they refer to row numbers, you need to insert a column and type the numbers in the inserted column. Select this range of data, and insert an XY chart. Double click the Y axis, and on the Scale tab (in 2003, if it's 2007 it's on the main tab), change the minimum to 23 and the maximum to 30. With the chart selected go to Tools menu Options Chart tab, and near the top where it says Plot Empty Cells As, choose Interpolated. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "joe925c" wrote in message ... On my Excel sheet I have the following: 1 st br pa 2 23.5 3 25.3 4 25.5 25 24 5 26.1 6 28.5 On one chart, would like to see points and lines as follows with the x axis 1-6 and y axis from 23 to 30 and for "st" a line from 25.3 to 25.5 to 28.5: for "br" 23.5 to 25 and for "pa" 24 to 26.1. This is a sample of height measurements for three grandsons taken a various time but not equivalent in age (above in months). When I select an XY scatter chart I get restricted to only two of the three columns. Help appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to click on charts & unable to create any new charts Excel | Charts and Charting in Excel | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
Charts - How to have multiple charts share a legend. | Charts and Charting in Excel | |||
interactive charts for stacked bar charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel |