Fixing a Graphic in Excel

EE Pros,

I'm in the final stages of a graphic I have developed and am simply trying to place the Description Text (Text1, Text2, etc.) into the data points (the Balls on the Graphic).  

Graphic attached.

Thank you in advance,

B.
Adding-Text-to-Data-Points.xlsm
Bright01Asked:
Who is Participating?
 
Ejgil HedegaardCommented:
Select the first dataseries.
Right click and add datalabels.
Select the datalabels, right click and select format datalabels.
Change Y-values to X-values, and placement to center.
Select the datalabels, and select label number 5, so only one is selected, and delete it.
Do the same for the remaining labels (6-9), = select the labels, select one and delete it.

Repeat the above for the second series, but delete label 1-4.

The text box will automatically resize to fit the text.

To get 2 lines, insert a line break in the description text in L27 to L35.
Manually (in L27): Text1 line 1 Alt+Enter Text1 line 2

With formula: ="Text1 line 1"&CHAR(10)&"Text1 line 2"
"Text1 line 1" can be a cell reference.

To change text format, select the labels, and change the font, size, colour etc.
0
 
Ejgil HedegaardCommented:
0
 
Bright01Author Commented:
YES!  Except, how do I do that and how can I reduce the size of the box to get two lines of explanation vs. 1?

B.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Bright01Author Commented:
How do I change the size of the text box?
0
 
Glenn RayExcel VBA DeveloperCommented:
You could add a linefeed character inside the description cells to break into two lines.  Press [Alt]+[Enter] after the first line, then enter the second.  See the attached example.

Regards,
-Glenn
EE-Adding-Text-to-Data-Points.xlsm
0
 
Bright01Author Commented:
Glenn,  I couldn't get Alt.+Enter to add a CR.  What am I doing wrong?  I looked at your example but couldn't make it work either.

Ejgil,  I tried your solution but right off the bat, I'm not sure how to select the first data series....do I do that through the select Design + Select Data?

B.
0
 
Glenn RayExcel VBA DeveloperCommented:
Ejgil has provided most of the solution, so no points here.

As you're typing the text labels in cells L27:L35, you'll press [Alt]+[Enter] simultaneously to get the linefeed, then continue typing what will be the second line.  When you then press [Enter], the labels will automatically display multiple lines.

-Glenn
0
 
Ejgil HedegaardCommented:
Use the mouse to select the data series or data labels directly on the chart.
Just point at it and left click.
When the data labels are selected, clicking on one of them select that one.
0
 
Bright01Author Commented:
Sorry for the delay... I've been swamped at work.  Your solution worked great!!!!  My graphic is now working perfectly thanks to you.   Thank you very much.

B.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.