Pivot Chart adding a Trendline line or baseline

**Ted Dennis** · 09-15-2013, 10:29 AM

I have a pivot chart detailing a list of vehicles and times.

The chart is a bar chart with time on the vertical axis and vehicles on the horizontal axis. I need a constant / benchmark of 5hrs showing across the chart as a form of a trendline. I have tried to use the trendlines but as these are all mathematical I can't enter what I want. I know if I create a table from the pivot I can just add the 5 hrs as part of the table and then when selecting the data do it that way. But can this be done in a pivot chart ?

Thanks

**Andy Pope** · 09-16-2013, 03:41 AM

You can add a calculated field

**Mfate** · 05-21-2014, 04:44 PM

Andy,
I downloaded your spreadsheet and I'm scratching my head trying to find the "baseline" informaation. Yes, it shows up in the pivot table and chart but I don't see it in the source data. Can you explain?

Thanks,

**Andy Pope** · 05-22-2014, 04:58 AM

It's not in source data. It's a calculated field

**Mfate** · 05-22-2014, 10:01 AM

The term "calculated field" was foreign to me but after looking it up I get it now. Thanks for your help.

**tibbetjr** · 11-15-2015, 04:53 PM

This worked perfectly - Thank you so much!

**tibbetjr** · 11-16-2015, 10:34 AM

Does anyone know how to use this same method with multiple items in the data set?
I want to show 98% as the baseline for the "State" field and the chart shows the sum of the baseline for each state I have. Is it possible to just have the one baseline across the top as mentioned in the spreadsheet above?
snap00259.jpg

**tibbetjr** · 11-16-2015, 01:05 PM

I saw a similar thread below and was able to get what I needed from that. Here it is in case anyone else might need the information.

http://www.excelforum.com/excel-char...vot-chart.html

Pivot Chart adding a Trendline line or baseline

LinkBack

Thread Tools

Rate This Thread

Display

Pivot Chart adding a Trendline line or baseline

Re: Pivot Chart adding a Trendline line or baseline

Re: Pivot Chart adding a Trendline line or baseline

Re: Pivot Chart adding a Trendline line or baseline

Re: Pivot Chart adding a Trendline line or baseline

Re: Pivot Chart adding a Trendline line or baseline

Re: Pivot Chart adding a Trendline line or baseline

Re: Pivot Chart adding a Trendline line or baseline

Thread Information

Users Browsing this Thread

Similar Threads

Pasting Pivot Chart Format or using slicers Changes Pivot Table data Reference

[SOLVED] Multiple Columns in Pivot Table (but don't show in Pivot Chart)

[SOLVED] Excel 2007 : Is it possible to change source data in pivot table and pivot chart wizard??

Excel 2007 : Chart lines are too thick using default templates and Pivot table/chart

Editing Pivot Chart Y axis or Multiple Pivot Charts On the Same Page to Compare Data

Bookmarks

Bookmarks

Posting Permissions