+ Reply to Thread
Results 1 to 2 of 2

Removing specific data "of a series" from a chart only

  1. #1
    Registered User
    Join Date
    11-01-2011
    Location
    Ohio
    MS-Off Ver
    Excel 2016
    Posts
    15

    Question Removing specific data "of a series" from a chart only

    I'm in a time cruch with a problem...

    I have a combination chart with data from Sun thru Sat (7 days). My manager wants to display only the weekday data (M,T,W,Th,F) and remove the weekend data (Sat,Sun). However, I also need this data to be included in other charts I need. I was thinking in years past, that I was able to remove specific data from the chart directly without having to alter or change the spreadsheet data? Any thoughts or comments?

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Removing specific data "of a series" from a chart only

    Hello,

    You can hide rows and their numbers won't appear in a chart.

    Or if you use a pivot chart, you can use filters to determine what data to show.

    Difficult to be more precise without seeing a sample of chart and underlying data.

    cheers,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1