| Home |
| Search |
| Today's Posts |
|
#1
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
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there an easy way to align charts? | Excel Discussion (Misc queries) | |||
| Significance of _- in custom format | Excel Discussion (Misc queries) | |||
| An easy way to changing refrence on several charts | Charts and Charting in Excel | |||
| Showing Significance Testing in Bubble Charts | Charts and Charting in Excel | |||
| = sign has no significance. | Excel Worksheet Functions | |||
Linear Mode
