L LMAO Jan 26, 2004 #1 I have a column of dates and they're all weekdays. Next to it is a column of prices. When I create a chart in Excel by highlighting both columns, Excel inserts weekends into the chart. How can I stop this? Thank you
I have a column of dates and they're all weekdays. Next to it is a column of prices. When I create a chart in Excel by highlighting both columns, Excel inserts weekends into the chart. How can I stop this? Thank you
M mmm Jan 26, 2004 #2 Poke around the options and set the X-axis values as categories. That should do the trick for you.
L LMAO Jan 26, 2004 #3 Quote from mmm: Poke around the options and set the X-axis values as categories. That should do the trick for you. More... great! thanks!
Quote from mmm: Poke around the options and set the X-axis values as categories. That should do the trick for you. More... great! thanks!