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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Bright01Author Commented:
How do I change the size of the text box?
0
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.