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=###
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...