Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Show significiance between 2 bars

I want to put a line that connects two bars in Excel, and put different
values on top of it, like correlations or significances between the two bars.
Example: http://hawaii.edu/mri/excel.jpg

Right now, I am doing each by hand. I open it in PowerPoint, and then use
the shapes and text boxes to connect everything. Does Excel have a feature
to do this more-or-less automatically?

Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Show significiance between 2 bars

Select the chart, click on the Layout tab and draw the shape you want. Use
the Format tab the rotate the shape. Add a text box above shape.

"snowrider" wrote:

I want to put a line that connects two bars in Excel, and put different
values on top of it, like correlations or significances between the two bars.
Example: http://hawaii.edu/mri/excel.jpg

Right now, I am doing each by hand. I open it in PowerPoint, and then use
the shapes and text boxes to connect everything. Does Excel have a feature
to do this more-or-less automatically?

Thank you.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Show significiance between 2 bars

Thank you Sue. Is there anyway to have Excel do this more-or-less
automatically for you?

Thank you again.

"SueW" wrote:

Select the chart, click on the Layout tab and draw the shape you want. Use
the Format tab the rotate the shape. Add a text box above shape.

"snowrider" wrote:

I want to put a line that connects two bars in Excel, and put different
values on top of it, like correlations or significances between the two bars.
Example: http://hawaii.edu/mri/excel.jpg

Right now, I am doing each by hand. I open it in PowerPoint, and then use
the shapes and text boxes to connect everything. Does Excel have a feature
to do this more-or-less automatically?

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
format a column to show bars light_wt Excel Worksheet Functions 1 October 21st 09 04:31 PM
Customise error bars on individual bars in a bar chart 2007 Millie Charts and Charting in Excel 2 April 25th 09 04:16 AM
How do I show scroll bars and tabs in Excel 2007 geoffa1 Setting up and Configuration of Excel 2 August 2nd 07 07:12 PM
How do i break really long bars to show short ones in Excel? nkchu83 Charts and Charting in Excel 2 May 26th 05 07:44 PM
eliminate scroll bars where lists are short, show all choices rtejral Excel Discussion (Misc queries) 1 November 29th 04 09:01 PM


All times are GMT +1. The time now is 08:36 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"