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?
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,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks