Excel charts

[g1knj99]

I am trying to help a user who has a unique request, at leat I think so.
She needs to create a bar graph that includes a "goal" line. Therefore, across the top, a straight line that indicates the target is set. The bars should go either above or below, indicating progress.
We tried some of the canned charts and can't find anything that helps.

 

[Dreamboat]

I've generally had people just make it another series on the chart.

For instance, make another column of data, call it GOAL, and put the same value in every cell. Regardless of the chart type of the other series, right-click this one and hit Chart Type and make it a line chart.

Anne Troy

http://www.VBAExpress.com

 

[SkipVought]

Hi,

There are a number of steps.

1. add a column/row of data that represents the Goal value -- the same value goes into each element

2. create your chart WITHOUT the goal data

3. copy the goal data

4. select the chart and choose edit/paste special and select new series in y or x depending on how your table is arranged.

5. in the chart, right click the ORIGINAL series and choose format to get the Format data series window. In the window select the axis tab and choose the secondary axis option button.

6. right click the new series to get format data series - select the patterns tab and choose NONE for borders - select the options tab and make overlap = 100 and gap width = 0.

VOLA!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com