|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 2nd, 2009, 08:12 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Is there an easy way to denote significance on charts
The only way I know how to add significance to charts, such as an asterisk
above a bar chart, is by adding a text box. Any adjustments to the chart require rearranging the text box. Adding significance to charts is quite common and I can't believe Excel would not have an easier option for this. 
|
|
#2
August 3rd, 2009, 01:31 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Is there an easy way to denote significance on charts
Another option is to apply shapes to hidden series. For example, if the
shape were an asterisk you could then control the position of the asterisk based on your source data. The asterisk could always appear over the bar even if the bar moved when the source data changed. -- John Mansfield http://www.cellmatrix.net "jpaderi" wrote: The only way I know how to add significance to charts, such as an asterisk above a bar chart, is by adding a text box. Any adjustments to the chart require rearranging the text box. Adding significance to charts is quite common and I can't believe Excel would not have an easier option for this.
|
|
#3
August 5th, 2009, 07:01 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Is there an easy way to denote significance on charts
As far as the significance markers can be characters (why not?) the most
natural way is labeling. Only asterisked items contain asterisk in the label range, the rest is empty. Follow Rob Bovey's http://www.appspro.com/Utilities/ChartLabeler.htm -- Petr Bezucha "jpaderi" wrote: The only way I know how to add significance to charts, such as an asterisk above a bar chart, is by adding a text box. Any adjustments to the chart require rearranging the text box. Adding significance to charts is quite common and I can't believe Excel would not have an easier option for this.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
