Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 106
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 106
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Chart - Remove Variables Marlyn Charts and Charting in Excel 2 May 25th 06 09:45 AM
How do I remove white space around a chart? Fred Zack Charts and Charting in Excel 1 March 9th 06 05:13 PM
zero value remove chart Graeme Charts and Charting in Excel 5 November 23rd 05 06:37 PM
How do I get the dates on an excel chart to stay as dates instead. Rani Charts and Charting in Excel 1 September 20th 05 05:56 PM
How to remove a data point in a chart? Vicky Charts and Charting in Excel 6 July 15th 05 05:27 PM


All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"