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.

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.

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.