Solved

Using a formula in Chart series X values

Posted on 2012-12-27
6
246 Views
Last Modified: 2013-01-14
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
0
Comment
Question by:AssetFX
  • 4
  • 2
6 Comments
 
LVL 2

Expert Comment

by:Dem_Akasha
ID: 38725110
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?
0
 

Author Comment

by:AssetFX
ID: 38725737
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
0
 
LVL 2

Expert Comment

by:Dem_Akasha
ID: 38728654
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.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:AssetFX
ID: 38729983
Hi Dem, appreciate your time! So silly right!
Regards Hank
0
 

Accepted Solution

by:
AssetFX earned 0 total points
ID: 38761513
I don't think this is possible so closing question.
0
 

Author Closing Comment

by:AssetFX
ID: 38773859
Answer is this is not possible.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
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…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question