Chart Quest...very stupid

Flue

Board Regular
Joined
Feb 5, 2009
Messages
106
Morning all. I'm sure this is a dumb a$$ question, but I am unable to come up with an answer, nor am I able to find one. :confused:

I have a 4 series Column Chart. I wish to use one series for a trend line. I can create the trend line, but how do I get rid of the column used for the trend with out removing the trend line?

I would then end up with 3 columns and 1 trend line. Right now I've got 4 columns and one trend line.

Thanks.
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Right click the series and choose Format Data Series. On the Patterns tab set Border and Area to None. You can also remove the legend - click twice so that the entry is selected and press Delete.
 

sulakvea

Well-known Member
Joined
Jul 2, 2008
Messages
994
a workaround - pick None for both Border and Patters of that bar thats extra, after adding a trendline to it.

then select the label for that bar, and delete it. no one will know there used to be an extra bar on the chart.

P.S. or do as Andrew said :)
 
Last edited:

Flue

Board Regular
Joined
Feb 5, 2009
Messages
106
ah...thanks. I was setting border and area to the same color as the chart area, but that Left breaks in the major axis lines.

See, told ya it was a dumb a$$ question.

I think I like adding an average line to the chart better, but it's more steps for the macro. I'll play with both and see which codes better.

Thanks again.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,509
Messages
5,529,274
Members
409,859
Latest member
emperorgenghiskhan
Top