Using a formula in Chart series X values

AssetFX
AssetFX used Ask the Experts™
on
Hi, attached is a screenshot of the data and chart I am working on. This sheet is called 'Road Model'
Excel Chart ScreenshotI am trying to get the value 2.675 into the Series X values.
The circled label represents the condition and I am using a scatter point to position it. (though I have made it invisible as  I just want the label).

What I would like to do is have a formula in the series X values textbox to create 2.675 value. I do not want an extra column in the data if I can help it. Something like the following:
='Road Model'!$F$31 + (('Road Model'!$G$31 - 'Road Model'!$F$31)/2)

I am going to be doing this programmatically, but if someone knows a manual way then I would be able to figure it out.

Kind regards Hank
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Are you able to provide a copy the spreadsheet?

Also you just want a label to show up and nothing else on the actual chart?

Author

Commented:
Hi Dem,

just attached a copy.

I would like to place a label centered above each line segment.

To do this so far I have created a series containing one point. And used the Series Name to hold the value of the "Condition", which is the label text I want to display.

So to answer your 2nd question, if you mean one of my label series being the only object being displayed yes, I don't want the series point to display.

The nice thing about this, if it works, will be if any of the lengths change, the lines and labels will move accordingly.

If you right click the chart and go into the Select Data you will see what I mean.

Regards Hank
ResealRegisterReport-2012-12-28-.xlsm
Hi Hank,

Sorry about the delay been trying to figure it out. Not a lot of progess to report at the moment. I will continue to work on it because there simply has to be a way, and now it's bugging me. I will let you knwo if I come up with anything.
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Author

Commented:
Hi Dem, appreciate your time! So silly right!
Regards Hank
Commented:
I don't think this is possible so closing question.

Author

Commented:
Answer is this is not possible.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial