LinkBack URL
About LinkBacks
How can I hide Series 3 from the below chart data table?
I want to show the series (i.e. Series 3) in the chart, but hide it from the chart data table.
bu7PH.png
How can I hide Series 3 from the below chart data table?
I want to show the series (i.e. Series 3) in the chart, but hide it from the chart data table.
bu7PH.png
Data table is linked to the chart. To hide a series on the data table you must hide the chart series as well.
Either hide the entire column D or Chart Tools > Design > Select Data > untick Series 3 of the Legend Entries (Series) > OK.
How to hide a series from MS Excel chart data table.png
But I want to show the series. Doing this will hide the series from chart also.Originally Posted by JieJenn
I want the series to be shown on the chart, but selectively hide the series from chart data table.
Last edited by AAKBD; 06-25-2021 at 03:12 AM.
Change cell format for D1:D15 to ";;;" and then remove Show legend keys in Data Table Options
It works! But one more issue with this...
"Series 3" should not be present here.
How to get rid of that?
Attachment 737814
Sorry, cannot open your attachment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks