Removing weekend/holiday dates - cont'd

G

GR

Sorry but I must be missing something. I'm with you until "Axis Options", but
under "Axis Options" I don't see anything that says "Axis Type" or anything
that gives me the option to have a text axis. Thanks

p.s. I am using a scatter chart
 
A

Andy Pope

Hi,

You can not see it because it is not there for scatter chart.
It a setting for Line/column/bar/area charts.

With a xy scatter the axis is purely numeric.

If you want to exclude dates you will need to change to Line chart in
order to treat each date as a category.

Cheers
Andy
 
G

GR

Thanks - I changed it to a line chart and that worked.

But I get a different problem when I do that. The range I am referencing for
the chart includes a bunch of empty cells at the end of the range (these
cells are updated automatically on a daily basis by an application that
writes data to the workbook). These aforementioned cells are completely
empty; i.e. no formulas or anything. The problem is that the line chart
continues to plot the empty values - I only want to plot the data from those
cells in the specified range that actually contain values. Can I do this for
a line chart? I tried playing around with the "Hidden and Empty Cells"
feature under Select Data but this did not resolve the issue - it seems like
this feature does not allow you to ignore (i.e. NOT plot) data with empty
cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates, And Their Corresponding Numbers: How To Show ? 0
Chart doesn't recognize date format 4
Excel 2007: Line where a gap should be, but only when plotting on ahorizontal date axis 2
move axes and axis labels behind data points on scatter chart 0
Formatting pivot chart axis labels for dates 10
Plotting Date and Time on the same chart axis 1
How to remove weekends from the chart 2
XY Charts Excluding Weekends 1

Top