View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
dan dan is offline
external usenet poster
Posts: 866
Default Show only workdays in chart axis?


I have created a dynamic named-range that I use as the data source for my
scatter plot chart's x-axis. I only type in dates that are workdays in that

When I graph my data the chart is still showing the weekends, just with no
data points in there. It is stretching my graph out and skewing the look.

Is there a way to set the graph to only show weekdays and just skip the