Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do create a line/scatter chart
i am trying to draw a graph to compare the weight of an item to the cost to
paint it, however in chart wizard it will only let me plot the two lots of information against each other, rather than putting the weight on the x axis, and the cost on the y axis and plotting points on the chart |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do create a line/scatter chart
Put the weights (X values) in one column and the corresponding costs (Y
values) in the next column to the right. Select this range, run the chart wizard, and choose XY chart (not Line chart) in step 1 of the wizard. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Naomi" wrote in message ... i am trying to draw a graph to compare the weight of an item to the cost to paint it, however in chart wizard it will only let me plot the two lots of information against each other, rather than putting the weight on the x axis, and the cost on the y axis and plotting points on the chart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a link between columns from a data chart? | Excel Discussion (Misc queries) | |||
able to automatically create a chart in Excel | Charts and Charting in Excel | |||
How to create a chart based on a 2 dim data range dynamical in 1 d | Charts and Charting in Excel | |||
Macro to Create a Chart and Update it Automatically | Charts and Charting in Excel | |||
How to create combination stacked area and line chart? | Charts and Charting in Excel |