Chart reading from some metrics in pivot table only

[AndyDevine1]

Hi there

In my pivot table I am now showing actual spend, forecast spend, actual applications and forecast applications by week.

How can I only show just spend and forecast spend by week on a chart (without removing them from the pivot)?

Many thanks!

Excel 2013

 

[SpillerBD]

I don't think you can. I usually add another Pivot Table to chart and link the Pivots by Slicer Connections.
However, I wonder if you could format the undesired series so they wouldn't be visible. (?) Can we choose "No fill" for the colors?

 

[AndyDevine1]

Thanks for you reply.

That has been my work-around...works ok for lines (as you can pick 'no lines' option)

For bar charts, there are gaps in the data so looks a little wierd...hence my post...as there is actually more than 4 metrics...i was simplifying