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
Chart with data table values from 2nd Y axis only
-
- 5StarLounger
- Posts: 736
- Joined: 18 Mar 2010, 11:05
Chart with data table values from 2nd Y axis only
You do not have the required permissions to view the files attached to this post.
-
- 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
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.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 736
- Joined: 18 Mar 2010, 11:05
Re: Chart with data table values from 2nd Y axis only
Thought it might be that way.
Thank you.
Thank you.