ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   remove dates from chart (https://www.excelbanter.com/charts-charting-excel/141294-remove-dates-chart.html)

Rebecca

remove dates from chart
 
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

Jon Peltier

remove dates from chart
 
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
_______


"Rebecca" wrote in message
...
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




Rebecca

remove dates from chart
 
Thanks

"Jon Peltier" wrote:

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
_______


"Rebecca" wrote in message
...
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






All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com