Ability 2 put * over single bar in graph 2 indicate stat sig

[Guest]

To indicated statistical significance in academic publishing we often place a
character (e.g. *) above a single bar in a graph. Currently one uses a text
box which moves and isn't the best. Make sure the character can be changed
with respect to size and intentisty.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...716d8bed29&dg=microsoft.public.excel.charting

 

[Jon Peltier]

Didn't I answer this in Mr Excel today?

In a column adjacent to the values, enter a formula that inserts * if
the value is significant, using this kind of logic:

=IF(<significant>,"*","")

Then use one of these free, easy to install and use Excel add-ins to use
this column as labels for the markers in the chart:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com/ss

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Hari Prasadh]

Hi Jon,

I have been able to download Rob's chart utility and found it useful.

I would like to try out JW's chart tool as well but couldnt find any tool
named chart tool available for download in his Charting section (User tips).

Please paste the link if possible as Im also doing some statistical
significance testing and would like to try both the tools.

Thanks a lot,
Hari
India

 

[Tushar Mehta]

Did you search John's site for 'Chart tools' (w/o the quotes)?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Hari Prasadh]

Hi Tushar,

Thnx.

Pretty foolish of me to assume that the link would be in one of the charting
specific pages (tips). It turned out to be under download files. Found some
other stuff as well.

And yes didnt search for chart tools.

Thanks a lot,
Hari
India