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

[ainsliek]

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/comm...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/
_______


ainsliek wrote:

> 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.
>

[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

"Jon Peltier" <[email protected]> wrote in message
news:[email protected]...
> 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/
> _______
>
>
> ainsliek wrote:
>
>> 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.

[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

In article <e#[email protected]>,
[email protected] says...
> 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
>
> "Jon Peltier" <[email protected]> wrote in message
> news:[email protected]...
> > 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/
> > _______
> >
> >
> > ainsliek wrote:
> >
> >> 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.
>
>
>

[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

"Tushar Mehta" <[email protected]> wrote in message
news:[email protected]...
> 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
>
> In article <e#[email protected]>,
> [email protected] says...
>> 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
>>
>> "Jon Peltier" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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/
>> > _______
>> >
>> >
>> > ainsliek wrote:
>> >
>> >> 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.
>>
>>
>>