Weekends on Excel graphs

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
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/
_______
 
Back
Top