Adding Industry Average Line

[RJB]

So I have data;

X Y
Plant 1 Y1
Plant 2 Y2
..
..
Plant N YN
Company Avg YAvg
Industry Avg YIA

(YAvg is a calc I do, YIA is plugged)

Now. I have a column chart where there's a column for Y1, Y2, etc. etc.

I'd like columns for Y1 - YN. But I'd like a horizontal line for YAvg and YIA.

I know I can "trick" it if I do a combo graph with separate columns of data:

X Y Co Ind
Plant 1 Y1 Yavg YIA
Plant 2 Y2 Yavg YIA
..
..
Plant N YN Yavg YIA

But that will get laborious for the many different charts I have to do.

i tried building the chart with just Y1 - YN as the columns, then adding
Yavg as a separate series, but since it's just a series of one, it only plots
the one point - not a line.

Any thoughts?

 

[Dave Curtis]

Hi there,
You're almost there. If you plot Yavg as an x-y (scatter) chart, you'll
indeed get a single point, so just add horizontal (x) error bars of the
correct length to draw a horizontal line for you, and format as required.

Dave

url:http://www.ureader.com/msg/10296825.aspx

 

[RJB]

Thanks. I had time on a plane, so I worked "around" it - for some reason I
couldn't get the X errors to come up earlier, but now I can. Oh, well!

Thanks!