Column vs Bar Chart Target Line

[SHefer]

Hi,

I have a simple Bar chart that needs to show a target line (at 100%). The data is generated from a Powerpivot table. For some reason, I can make get the graph to show exactly the way it should on a Column Graph, but as soon as I switch it to a Bar Graph, it goes haywire - I cannot get the Target Line to stick to the primary axis. Attached are a few screen shots to aid my explanation.

Any help/direction would be appreciated.

 

[NARAYANK991]

Hi ,

If you put the words

line bar chart

in the Search box in this forum , you can see the following link on Page 6 of the search results :

http://chandoo.org/forum/threads/adding-a-vertical-line-on-a-bar-chart.17215/

In that thread , you will find the following helpful link :

http://www.exceltactics.com/add-vertical-line-horizontal-bar-chart/

Narayan

 

[SHefer]

Thanks for the link, it is helpful. It is however not possible to add/use a scatter plot for a chart that has been created from a pivot table...

 

[Chihiro]

What you can do is show target as bar chart beside 5/31/2013 series.

Then remove all format (No fill, No line etc) then add trend line to the series.

It's a kludge, but only way I know how.

P.S. forgot to attach sample see my next post for attachment.

 

[NARAYANK991]

Hi ,

Do you mean a pivotchart or a chart created from the data within a pivot table ?

Narayan

 

[Chihiro]

Here's example for Pivot chart.

Set Series Overlap to 100%.
Then extend trend line by 0.5 period Forward and Backward.