Adam has attended:
Excel Intermediate course
Pivot Charts
Is it possible to display a threshold line within a Pivot Chart automatically (ie without having to draw a line within the chart)
RE: Pivot Charts
Hi Adam,
Thank you for the forum question.
The only line you automatically can add to a Pivot chart is a trend line. If you want a threshold line the threshold values must be in your Pivot Table.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Pivot Charts
Hi Jens - thanks for the clarification.
I don't think a 'trendline' is what i was after since wouldn't this alter depending on the data and what I wanted to display was a static line against which the data related bars/columns would be either above or below.
I'll try playing around with add a static 'threshold' value to my pivot-table but i'm not sure how i'd indicate to the pivot-chart that this one item of data is a static line whilst the other items are variable columns/bars.
Kind regards
Adam
RE: Pivot Charts
Hi Adam,
If you have the threshold value in your Pivot Table and create a column chart, you will get a column for each series. A column for your other value and a column for your threshold value. If you right click on one of the columns and click change chart type and scroll down in the dialog box which appear, you can change the threshold series to a line chart.
This will give you the line in your column chart.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
