Chart omitted on Slicer Connection Listing | Excel forum

Resolved · Urgent Priority · Version 2013

Tue 16 May 2017, 13:33 Delegate Lloyd said...

Lloyd has attended:
Excel PowerPivot course

Chart omitted on Slicer Connection Listing

I am working on a pre created data model, where there are a series of charts but one will not respond to change on date-month slicer settings.
When I click on slicer connections, the chart I wish to connect is not listed. I deleted the chart and recreated it, and it's still not listed on connections; hence I can't check to connect.

How do I connect a chart to the slicer, when the chart is not listed on slicer connections?

Thu 18 May 2017, 18:41 Trainer Jens said...

RE: Chart omitted on Slicer Connection Listing

Hi Lloyd,

Thank you for the forum question.

I guess you mean that you cannot see the PivotTable you have created the charts from listed on connections.

I have not been in a situation where the PivotTables are not listed on connections.

Have you tried to refresh the whole data model?

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best 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

Tue 30 May 2017, 14:36 Delegate Lloyd said...

RE: Chart omitted on Slicer Connection Listing

Hi Jens,

I have discovered that the pivot chart responded to a splicer on another page!!

I am not even going to try and understand this; it was not my data model, and I see no reason why I would want to connect a chart to a splicer on another sheet.

Kind regards.

Lloyd.

Tue 30 May 2017, 16:01 Trainer Jens said...

RE: Chart omitted on Slicer Connection Listing

Hi Lloyd,

Yes normally you would like to have the chart on the same sheet as the slicer. The slicer must control the PivotTable from which the chart is created.

Good luck with your data models.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best 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

Tue 6 Jun 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips