Microsoft Excel Graphing

1240 pts.
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
1

Answer Wiki

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

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • CompEng
    is it possible to show images of how this might look?
    1,240 pointsBadges:
    report
  • CompEng
    I will give this a try in the morning and let you know how it works out. I am vary new to this so that is why I asked or possible images ( or if possible a more simpler explanation, Thanks  
    1,240 pointsBadges:
    report
  • CompEng

       (1) Build a scatter chart with the original series and a range for the x-Axis.

    ComEng: This I was able to do....done.

  •     Copy the first two cells of the x-Axis range to a new range
  • ComEng: So when you say copy first two cells that would be A1 (1913) B1 (1914). So I am to copy these. When you say a new ran, what done this mean. How to a create a new range in the same graph? 
  • I am a beginner so go easy with me...take it to the basics ABC... and for the rest too, if you can explain it alittle more please, Thanks
  •    
  • 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
  • 1,240 pointsBadges:
    report
  • CompEng

    (1)  What do you mean by this "Copy the first two cells of the x-Axis range to a new range

    Would you be open to setting up a Dropbox to look at what I have and how to work it out.. I need a visual?

    1,240 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: