Home |
Search |
Today's Posts |
#1
|
|||
|
|||
XY Scatter charts
Hi
I cant for the life of me work out how to create the type of graph im after. I have two collumns of data-i want the first collumn to be the x values and the second collumn to be the Y values. I want excel to then plot these points on a scatter graph (eg a point on the graph will comprise of an X value and its corresponding Y value). Does anyone know how i can do this or where i can find out? Any help will be great as i am really starting to tear my hair out now!!! Pleeease! Thanks Steve |
#2
|
|||
|
|||
highlight the first and second column data
click the chart wizard icon which looks like colored bar graph in the toolbar choose scatter chart and follow the wizard. first column will be x values and second col y values. smintey wrote in message ... Hi I cant for the life of me work out how to create the type of graph im after. I have two collumns of data-i want the first collumn to be the x values and the second collumn to be the Y values. I want excel to then plot these points on a scatter graph (eg a point on the graph will comprise of an X value and its corresponding Y value). Does anyone know how i can do this or where i can find out? Any help will be great as i am really starting to tear my hair out now!!! Pleeease! Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i need help automating, or at least simplifying, my charts | Charts and Charting in Excel | |||
Can I use xy scatter charts to plot absolute measurements? | Charts and Charting in Excel | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
Locking the scale ratio of X-Y axis in XY scatter charts | Charts and Charting in Excel | |||
initial size of new charts | Charts and Charting in Excel |