## Microsoft Excel Graphing  Tags:
Excel Graph
Microsoft Excel
I has been awhile since I have used this site. Most of my posted in the past have been with SQL. Now I am in a new industry. So Now I am working on a presentation in the financial world. I have compiled a graph of all the high or top income paying percentages starting for 1913 till 2013 (100 yrs) I was not sure how to graph it. I wanted to be able to include all the percentages for 0 to whatever the max for each year would have been ( excluding the incomes areas). I since I was not able to develop that even though I have all the data. What I did then was created a graph only using the max percentages for each year. So how I have a graph. Each bar on the graph ( 100 or them) shows the year on the "X" axis and the percentage on the "Y" axis. So the only number in the data series is the max number and the years. How for the question I need to ask. What I need is a line that expanse horizontally across the graph and is either able to be slide up and down the graph. The reason is I what to be able to rest this slide line on the max of any bar ( income percentage/ year) then assign a macro or a VBA code that would be able to calculate the average of all the income average. Is this possible or not. If so, Look and I need to know specifics and I have been give a link to MS site that really didn't not help. I need to know if this line can be assigned a macro or a VBA code. If there are other means of making this happen I am open to other suggestions too. Thanks

Software/Hardware used:
Window 7 prof, 32 bit, office 2010

Thanks. We'll let you know when a new response is added.

You can do this in a scatter chart:

•     Build a scatter chart with the original series and a range for the x-Axis.
•     Copy the first two cells of the x-Axis range to a new range
•     Add two y-Values to the right of the new x-Axis cells, make the values equal to the minimum of the original series y-Values.
•     Add two new series based on the two new cells – these series will have a single point.
•     Format the two new series to have 100% y-Error bars.
•     You may have to explicitly set the y-Scale minimum / maximum values

Now
you should have two vertical lines (the error bars). Users can move
these by clicking on the point which can be on the x-Axis or just above
it. The x-Values change on the worksheet when users move one of these
points, so it should be easy to do calculations with them.

## Discuss This Question: 4 Replies 