Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
inserting specific points on a graph and label them?
Hi, i have excel 03 and have creating a xy scatter graph of frequency
response and i need to mark 2 specific points on the graph and label them. Does anyone know how to do this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
inserting specific points on a graph and label them?
On Wed, 12 Dec 2007, in microsoft.public.excel.charting,
cj_69 said: Hi, i have excel 03 and have creating a xy scatter graph of frequency response and i need to mark 2 specific points on the graph and label them. Does anyone know how to do this? Create the following table in a convenient part of your spreadsheet: x1 y1 Comment1 x2 y2 Comment2 Select the first two columns (not the third, for now), and use Copy, Paste Special to add them to your XY chart as a new series. When the Paste Special dialogue invites parameters, choose these: Add cells as: New series Values (Y) in: Columns (the odds are good that the default will guess wrongly, so change it) Series names in first row: NO (unless you actually want to name the y column: if so, add a name row in the table I suggest above) Categories in First column: YES Replace existing categories: NO Now since you've only got two points, you may as well add the comments manually: select the series and give it data labels. "Show value" or "Show label" is not important, as we're going to alter these anyway. Select one label, select it again until just that label is selected and not the range. Click in the edit bar at the top of the screen and type "=", then select the comment cell and Enter the formula. Now you have a comment in the spreadsheet shown at the fixed point on the XY chart. Alternatively, you can do it really manually and type the text comment in the data label, replacing the value. If you have a column of lots of comments or labels, you can use one of the free add-ins that can be found on the web to automate this edit process. Kelly O'Day has a good example to show how you can do this at: http://processtrends.com/pg_charts_t...ith_events.htm -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
inserting specific points on a graph and label them?
Click twice on a data point to select it, right-click, select Format Data
Point/ Data Labels/ select one or more of the options (series name, X value, or Y value). When you've added a label, you can select it and edit it, replacing the existing text by new text which you type in. -- David Biddulph "cj_69" wrote in message ... Hi, i have excel 03 and have creating a xy scatter graph of frequency response and i need to mark 2 specific points on the graph and label them. Does anyone know how to do this? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
inserting specific points on a graph and label them?
Sorry the i would like to insert a point that is not a point on the scatter
graph so i want to add a point that is not already existing. "David Biddulph" wrote: Click twice on a data point to select it, right-click, select Format Data Point/ Data Labels/ select one or more of the options (series name, X value, or Y value). When you've added a label, you can select it and edit it, replacing the existing text by new text which you type in. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
inserting specific points on a graph and label them?
So you need to add a new point to your series, or a new series including
your new point. -- David Biddulph "cj_69" wrote in message ... Sorry the i would like to insert a point that is not a point on the scatter graph so i want to add a point that is not already existing. "David Biddulph" wrote: Click twice on a data point to select it, right-click, select Format Data Point/ Data Labels/ select one or more of the options (series name, X value, or Y value). When you've added a label, you can select it and edit it, replacing the existing text by new text which you type in. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
inserting specific points on a graph and label them?
Even easier:
Set up the added data like this: Label1 Label2 X1 Y1 X2 Y2 Copy the data, select the chart, use Paste Special to add the data as new series, with series in columns. This gives you two series, each with one visible point. Right click one of these, add data labels, using the series name option. Select the other and press F4 to repeat last action (F4 probably won't work in 2007). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Del Cotter" wrote in message ... On Wed, 12 Dec 2007, in microsoft.public.excel.charting, cj_69 said: Hi, i have excel 03 and have creating a xy scatter graph of frequency response and i need to mark 2 specific points on the graph and label them. Does anyone know how to do this? Create the following table in a convenient part of your spreadsheet: x1 y1 Comment1 x2 y2 Comment2 Select the first two columns (not the third, for now), and use Copy, Paste Special to add them to your XY chart as a new series. When the Paste Special dialogue invites parameters, choose these: Add cells as: New series Values (Y) in: Columns (the odds are good that the default will guess wrongly, so change it) Series names in first row: NO (unless you actually want to name the y column: if so, add a name row in the table I suggest above) Categories in First column: YES Replace existing categories: NO Now since you've only got two points, you may as well add the comments manually: select the series and give it data labels. "Show value" or "Show label" is not important, as we're going to alter these anyway. Select one label, select it again until just that label is selected and not the range. Click in the edit bar at the top of the screen and type "=", then select the comment cell and Enter the formula. Now you have a comment in the spreadsheet shown at the fixed point on the XY chart. Alternatively, you can do it really manually and type the text comment in the data label, replacing the value. If you have a column of lots of comments or labels, you can use one of the free add-ins that can be found on the web to automate this edit process. Kelly O'Day has a good example to show how you can do this at: http://processtrends.com/pg_charts_t...ith_events.htm -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I easily label 200 different data points on a buble chart? | Charts and Charting in Excel | |||
How do I label data points in a scatter graph | Charts and Charting in Excel | |||
label invidual points in an XY scattergraph | Excel Discussion (Misc queries) | |||
label points on an XY graph | Charts and Charting in Excel | |||
Excel graphs with 1,000 or more points should not auto label | Charts and Charting in Excel |