Thread: Plotting Data When There Is A "Jump" or Transition To Jan. Of NewYear ?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Plotting Data When There Is A "Jump" or Transition To Jan. Of New Year ?
Hi Robert,

Am Mon, 5 Feb 2018 06:07:06 -0800 (PST) schrieb Robert11:

When I format the, e.g., 22 Dec, as Text on the Data sheet, what appears is a big number, like 45000.

keep the date in the data sheet as date.
Right click to the x axis = Format axis = Text axis.
Tell me how many days or month you will show with your chart and send me
your workbook.


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote