Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
L L is offline
external usenet poster
 
Posts: 12
Default how do i put an asterisk on a bar chart to show significance

thank you
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: how do i put an asterisk on a bar chart to show significance

Hi there! Adding an asterisk to a bar chart in Microsoft Excel is a great way to indicate statistical significance. Here's how you can do it:
  1. First, create your bar chart by selecting the data you want to use and clicking on the "Insert" tab in the top menu.
  2. Choose the type of chart you want to create, such as a column chart or a bar chart.
  3. Once your chart is created, click on one of the bars to select it.
  4. Right-click on the selected bar and choose "Format Data Series" from the drop-down menu.
  5. In the "Format Data Series" pane that appears on the right-hand side of the screen, click on the "Marker Options" tab.
  6. Check the box next to "Built-in" under "Marker Type."
  7. Choose the symbol you want to use as your asterisk from the drop-down menu under "Marker Style." The asterisk symbol is usually located near the bottom of the list.
  8. Adjust the size and color of the asterisk as desired.
  9. Click "Close" to apply the changes to your chart.

That's it! Your bar chart should now have an asterisk symbol on the selected bar to indicate statistical significance. Repeat these steps for any other bars you want to mark with an asterisk.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default how do i put an asterisk on a bar chart to show significance

Apply a data label to the plotted point, and edit the text of the label to
show an asterisk. This could be automated as well.

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


"L" wrote in message
...
thank you



  #4   Report Post  
Posted to microsoft.public.excel.charting
L L is offline
external usenet poster
 
Posts: 12
Default how do i put an asterisk on a bar chart to show significance

Thank you Jon - I had to figure it out right away so I ended up putting a
little text box on top of the graph. Your way is better!
Thank you

"Jon Peltier" wrote:

Apply a data label to the plotted point, and edit the text of the label to
show an asterisk. This could be automated as well.

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


"L" wrote in message
...
thank you




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Significance of _- in custom format dee Excel Discussion (Misc queries) 2 March 29th 07 07:50 PM
Showing Significance Testing in Bubble Charts SteveChap Charts and Charting in Excel 1 June 13th 06 02:09 PM
How do I insert symbol to indicate significance on a bar graph? Hans Coetzee Charts and Charting in Excel 1 November 5th 05 04:34 AM
= sign has no significance. Gary Adamson Excel Worksheet Functions 1 December 9th 04 07:19 PM


All times are GMT +1. The time now is 10:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"