We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Solved
Using a formula in Chart series X values
Posted on 2012-12-27
Hi, attached is a screenshot of the data and chart I am working on. This sheet is called 'Road Model'
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
2
6 Comments
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?
Also you just want a label to show up and nothing else on the actual chart?
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
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.
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.
Featured Post
This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results.
Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Course of the Month14 days, left to enroll
656 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.