asked on
Hi, attached is a screenshot of the data and chart I am working on. This sheet is called 'Road Model'
![Excel Chart Screenshot]()
I 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
I 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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.