• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Trend Lines, changing from y= to Goal= [SOLVED]

M

mmmaclea

New Member
I have a chart in excel and I want to put in a horizontal goal line, that will update depending on the goal each month. I created a list of identical values and added that in "Legend Entries" in "Select Data". Then I made the bar graphs overlap and changed the fill to "no fill", but added a trend line to the graph. So I have a bar graph with current values, and a line going across the whole chart that is my "GOAL". However, the displayed trend line has "y = ######". I would like it to say "Goal = #####". However, when I attempt to change the text, it no longer updates when I change the values making that goal. Is there a way to do this?
 
Rather than using XL's trend line, I'd recommend setting up some formulas to calculate where the line needs to be, and then plotting that line on your chart. Remember that you can mix & match different chart types to have a line going across a column chart.
 
The only way I know how to have multiple chart types is by laying one chart over the other. I need everything to be in one chart because I need to copy it to PowerPoint and link it. I just can't get rid of the "y=". Right now I got the label to say y=Goal=###
 
Check out Chandoo's tutorial here:

http://chandoo.org/wp/2009/01/05/excel-combination-charts/


It is a single chart.
 
You must log in or register to reply here.
Back
Top