G Guest May 2, 2007 #1 I am new at creation of charts. I do not have the weekends in my data but they keep showing up in my chart? Can they be removed? Thanks
I am new at creation of charts. I do not have the weekends in my data but they keep showing up in my chart? Can they be removed? Thanks
J Jon Peltier May 2, 2007 #2 In a line or column chart, the default axis type when Excel recognizes dates in a time-scale axis. Change this to a category axis: Chart menu > Chart Options > Axes tab, select Category under Primary Category (X) Axis. - Jon
In a line or column chart, the default axis type when Excel recognizes dates in a time-scale axis. Change this to a category axis: Chart menu > Chart Options > Axes tab, select Category under Primary Category (X) Axis. - Jon
G Guest May 2, 2007 #3 Thanks Jon Peltier said: In a line or column chart, the default axis type when Excel recognizes dates in a time-scale axis. Change this to a category axis: Chart menu > Chart Options > Axes tab, select Category under Primary Category (X) Axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ Click to expand...
Thanks Jon Peltier said: In a line or column chart, the default axis type when Excel recognizes dates in a time-scale axis. Change this to a category axis: Chart menu > Chart Options > Axes tab, select Category under Primary Category (X) Axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ Click to expand...
