Chart with data table values from 2nd Y axis only

Egg 'n' Bacon
5StarLounger
Posts: 736
Joined: 18 Mar 2010, 11:05

Chart with data table values from 2nd Y axis only

Post by Egg 'n' Bacon »

Subject pretty much says it all.
But a little background - a request has come in to display the values for a single data series (this is on the secondary Y axis), at the bottom of the chart.
Adding data table gives more than is wanted?????

I have included a sample (OK, pivot based, but needs to work with non-pivot too) and would like to only display the 'Sum of %TTL' row.

Thanks in advance

E 'n' B
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78790
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Chart with data table values from 2nd Y axis only

Post by HansV »

That is not possible with the data table feature - it is all or nothing. As a (clumsy) alternative, you can create your own data table below the chart - see the attached version.
Book2.xlsx
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

Egg 'n' Bacon
5StarLounger
Posts: 736
Joined: 18 Mar 2010, 11:05

Re: Chart with data table values from 2nd Y axis only

Post by Egg 'n' Bacon »

Thought it might be that way.

Thank you.