ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Show significiance between 2 bars (https://www.excelbanter.com/excel-discussion-misc-queries/259313-show-significiance-between-2-bars.html)

snowrider

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.

SueW

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.


snowrider

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.



All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com