We help IT Professionals succeed at work.

Hide/remove a date on the horizontal axis of a chart

agwalsh
agwalsh used Ask the Experts™
on
Hi
I have a chart with dates - what I want is for the chart to exclude/hide public holidays. How do I do that without removing the date from the data series? So what I want is the date (and the lack of activity) on that date NOT to appear in my chart.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Finance Analyst
Commented:
Assuming you have a table of data with a row or column of data for each individual day, if you hide the particular row/column for the day that you need hiding in the graph it will not show in the graph but you will still have the data in the table.

Thanks
Rob H

Author

Commented:
Simple elegant solution. Thank you..