Exclude weekends in chart

**gnoke** · 08-18-2010, 06:47 AM

Hi,

I have a spreadsheet with dates in one column and values in the next.
I have no dates or values in weekend-dates, but since the x-azis is time scaleformated, they appear in the chart, making it look a bit weird....

Can anyone please guide me on how to exclude these dates?

Gnoke

**johnjohns** · 08-18-2010, 07:02 AM

I think you can hide the rows with weekends and the graph changes. To find the day from a date use

Please Login or Register  to view this content.

if the date is given in cell A1

To understand your problem better, please provide a sample workbook

rgds

johnjohns

**teylyn** · 08-18-2010, 07:09 AM

gnoke,

charts depend very much on the data layout of the source data. Post a workbook, otherwise all advice will be just guesswork.

cheers

**Andy Pope** · 08-18-2010, 08:00 AM

Make sure the axis is being treated as Catgeory (Text) rather than Time Series (Date)

**gnoke** · 08-18-2010, 08:03 AM

Thanks johnjohns, that did the trick!

And Andy Pope, you made it even easier, perfect!

Teylyn, I understand and will provide a sample workbook for furture chart questions

Gnoke