Weekends on Excel graphs

[Guest]

How do I get rid of weekends from showing up on Excel graphs when they are
not in my data set. I am plotting stock prices over time and Excel
automatically adds in weekends and holidays on the graph when these dates are
not even included in my data set. Please help!

 

[Don Guillett]

Here's one I suggested recently. Autofilter on any column that is blank. Be
sure to unfilter on sheet deactivate.

Private Sub Chart_Activate()
Application.ScreenUpdating = False
With Sheets("Daily Data")
x = .Range("a65536").End(xlUp).Row
.Range("a1:q" & x).AutoFilter Field:=2, Criteria1:="<>"
End With
Application.ScreenUpdating = True
End Sub

If that's not your problem then try chart options>axes>CATEGORY

 

[Jon Peltier]

Scott -

Choose Chart Options from the Chart menu, then click on the Axes tab. Check the
Category box under Primary Category X Axis. Automatic or Time Scale for X axis dates
will give a timeline, which by definition includes all the dates.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______