Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graphical co-ordinates format data label (with brackets) for chart
Hi all!
Using Excel 2007, I have made a chart using a data series with the x-values in one column and the y-values in another. I wish to show the data label for these points, but want to include the brackets to replicate the mathematical way of expressing the co-ordinate i.e. that the data label would read (-8, 6) instead of -8, 6. I've tried creating a custom data label using format codes, but I'm getting nowhere fast. Can anyone help please? Also, I have a second series on the same graph that I do NOT want to display this information (I'm making a teaching resource). It does not have a data label, but if you hover the mouse over it, it does display the coordinate. Can I turn this off? Many thanks in advance, Neil |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graphical co-ordinates format data label (with brackets) for chart
Hi,
To turn off the tooltips select the chart and use, Office button Excel Options Advanced Display Show data point values on hover. You can create the brackets using a couple of approaches. First use a helper column to build the text for your data. So if your x and y values are in A2 and B2 then in C2 use ="(" & A2 & "," & B2 & ")" You can then use this free addin to link data labels to cells. http://www.appspro.com/Utilities/ChartLabeler.htm Another way is to use custom number format. For your X values use (General For you Y values use General) You can now use data labels displaying both x and y value separated by comma. You will need to format both the x and y axes to have General number format in order to remove the brackets from the axis labels. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Neil Goldwasser" wrote in message ... Hi all! Using Excel 2007, I have made a chart using a data series with the x-values in one column and the y-values in another. I wish to show the data label for these points, but want to include the brackets to replicate the mathematical way of expressing the co-ordinate i.e. that the data label would read (-8, 6) instead of -8, 6. I've tried creating a custom data label using format codes, but I'm getting nowhere fast. Can anyone help please? Also, I have a second series on the same graph that I do NOT want to display this information (I'm making a teaching resource). It does not have a data label, but if you hover the mouse over it, it does display the coordinate. Can I turn this off? Many thanks in advance, Neil |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graphical co-ordinates format data label (with brackets) for c
Thanks for your reply Andy.
Just a few questions... (1) If I turn off the tooltips in the way that you suggest, is that option attached to the file or the computer running it? (I plan to share this resource with my students, so I'd rather that setting just happens for this one file, rather than them having to alter settings that will affect EVERY Excel file that they open, as it is a useful feature when it isn't allowing them to cheat on this one particular file!) (2) Will my students also need the add-in installed for the data labels to come up the same on their computer? (3) I tried altering the number format of the input values, but it does not handle negative numbers properly, e.g. if the x-value is -8 and the y-value is 6, it displays as -(8, 6) Any ideas? Again, many thanks for your help, Neil "Andy Pope" wrote: Hi, To turn off the tooltips select the chart and use, Office button Excel Options Advanced Display Show data point values on hover. You can create the brackets using a couple of approaches. First use a helper column to build the text for your data. So if your x and y values are in A2 and B2 then in C2 use ="(" & A2 & "," & B2 & ")" You can then use this free addin to link data labels to cells. http://www.appspro.com/Utilities/ChartLabeler.htm Another way is to use custom number format. For your X values use (General For you Y values use General) You can now use data labels displaying both x and y value separated by comma. You will need to format both the x and y axes to have General number format in order to remove the brackets from the axis labels. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Neil Goldwasser" wrote in message ... Hi all! Using Excel 2007, I have made a chart using a data series with the x-values in one column and the y-values in another. I wish to show the data label for these points, but want to include the brackets to replicate the mathematical way of expressing the co-ordinate i.e. that the data label would read (-8, 6) instead of -8, 6. I've tried creating a custom data label using format codes, but I'm getting nowhere fast. Can anyone help please? Also, I have a second series on the same graph that I do NOT want to display this information (I'm making a teaching resource). It does not have a data label, but if you hover the mouse over it, it does display the coordinate. Can I turn this off? Many thanks in advance, Neil |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graphical co-ordinates format data label (with brackets) for c
Hi,
(1) It's an application level setting, so every file. (2) Only the person building the chart will require the addin. The addin autos this technique. http://www.andypope.info/tips/tip001.htm (3) Try expanding the X values number format to (General;(-General;(General Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Neil Goldwasser" wrote in message ... Thanks for your reply Andy. Just a few questions... (1) If I turn off the tooltips in the way that you suggest, is that option attached to the file or the computer running it? (I plan to share this resource with my students, so I'd rather that setting just happens for this one file, rather than them having to alter settings that will affect EVERY Excel file that they open, as it is a useful feature when it isn't allowing them to cheat on this one particular file!) (2) Will my students also need the add-in installed for the data labels to come up the same on their computer? (3) I tried altering the number format of the input values, but it does not handle negative numbers properly, e.g. if the x-value is -8 and the y-value is 6, it displays as -(8, 6) Any ideas? Again, many thanks for your help, Neil "Andy Pope" wrote: Hi, To turn off the tooltips select the chart and use, Office button Excel Options Advanced Display Show data point values on hover. You can create the brackets using a couple of approaches. First use a helper column to build the text for your data. So if your x and y values are in A2 and B2 then in C2 use ="(" & A2 & "," & B2 & ")" You can then use this free addin to link data labels to cells. http://www.appspro.com/Utilities/ChartLabeler.htm Another way is to use custom number format. For your X values use (General For you Y values use General) You can now use data labels displaying both x and y value separated by comma. You will need to format both the x and y axes to have General number format in order to remove the brackets from the axis labels. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Neil Goldwasser" wrote in message ... Hi all! Using Excel 2007, I have made a chart using a data series with the x-values in one column and the y-values in another. I wish to show the data label for these points, but want to include the brackets to replicate the mathematical way of expressing the co-ordinate i.e. that the data label would read (-8, 6) instead of -8, 6. I've tried creating a custom data label using format codes, but I'm getting nowhere fast. Can anyone help please? Also, I have a second series on the same graph that I do NOT want to display this information (I'm making a teaching resource). It does not have a data label, but if you hover the mouse over it, it does display the coordinate. Can I turn this off? Many thanks in advance, Neil |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graphical co-ordinates format data label (with brackets) for c
Hi again!
Thank you very much - all sorted now. (1) To get around the tooltips issue without the students having to change their settings, I protected the chart and the worksheet, making sure that the user cannot edit objects. My students can't cheat now! (2) In the end I went with creating the custom data label format and checking "linked to source" on the options for the data labels - works a treat now that negative numbers are handled correctly. Again, many thanks for your help, it is much appreciated. Neil "Andy Pope" wrote: Hi, (1) It's an application level setting, so every file. (2) Only the person building the chart will require the addin. The addin autos this technique. http://www.andypope.info/tips/tip001.htm (3) Try expanding the X values number format to (General;(-General;(General Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Neil Goldwasser" wrote in message ... Thanks for your reply Andy. Just a few questions... (1) If I turn off the tooltips in the way that you suggest, is that option attached to the file or the computer running it? (I plan to share this resource with my students, so I'd rather that setting just happens for this one file, rather than them having to alter settings that will affect EVERY Excel file that they open, as it is a useful feature when it isn't allowing them to cheat on this one particular file!) (2) Will my students also need the add-in installed for the data labels to come up the same on their computer? (3) I tried altering the number format of the input values, but it does not handle negative numbers properly, e.g. if the x-value is -8 and the y-value is 6, it displays as -(8, 6) Any ideas? Again, many thanks for your help, Neil "Andy Pope" wrote: Hi, To turn off the tooltips select the chart and use, Office button Excel Options Advanced Display Show data point values on hover. You can create the brackets using a couple of approaches. First use a helper column to build the text for your data. So if your x and y values are in A2 and B2 then in C2 use ="(" & A2 & "," & B2 & ")" You can then use this free addin to link data labels to cells. http://www.appspro.com/Utilities/ChartLabeler.htm Another way is to use custom number format. For your X values use (General For you Y values use General) You can now use data labels displaying both x and y value separated by comma. You will need to format both the x and y axes to have General number format in order to remove the brackets from the axis labels. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Neil Goldwasser" wrote in message ... Hi all! Using Excel 2007, I have made a chart using a data series with the x-values in one column and the y-values in another. I wish to show the data label for these points, but want to include the brackets to replicate the mathematical way of expressing the co-ordinate i.e. that the data label would read (-8, 6) instead of -8, 6. I've tried creating a custom data label using format codes, but I'm getting nowhere fast. Can anyone help please? Also, I have a second series on the same graph that I do NOT want to display this information (I'm making a teaching resource). It does not have a data label, but if you hover the mouse over it, it does display the coordinate. Can I turn this off? Many thanks in advance, Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to auto format Area Chart Data Label? | Charts and Charting in Excel | |||
Can I make a pie chart where the slices are also graphical? | Charts and Charting in Excel | |||
Label brackets switched around in 2003 | Charts and Charting in Excel | |||
Pivot Chart Data Label Format Question | Excel Discussion (Misc queries) | |||
Data Label Format | Excel Discussion (Misc queries) |