Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 5th 18, 11:36 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2018
Posts: 4
Default Plotting Data When There Is A "Jump" or Transition To Jan. Of NewYear ?

Hi,

Using the latest Excel. Probably should have stayed with Excel 2007, as it handled this without any problem.

I have a simple spreadsheet for my blood pressure.
Dates in one column, and the Systolic and Diastolic values in the next two columns.

The Dates I use in the data table are e.g., 15 Dec., 22 Dec.,
and then we go to: 4 Jan...etc.

Plots up fine as ling as there is no jump to Jan dates from the preceding Dec.
It doesn't know how to handle this transition, even though all the data is sequential.


For dates, I used the format like 24 May, 10 June, etc. on
the X Axis (and for the data values).

Plots fine up until 31 Dec.

The X Axis does show Dec. and Jan Labeling.
But if the Selected Data includes Jan, then the plot/graph turns blank.


Obviously it isn't sure if this Jan should be at the beginning of the table or here, at the end.
Apparently, it gets confused on how to handle, and does nothing.

Excel 2007 handled it fine.

You would think with everything being sequential, it would handle the transition from 23 Dec to 2 Jan., but it won't.

Really don't want to have to use the date formatting where the year is included, but may have to.

Thoughts on plotting data with this year transition in the format I
would really like as 27 Jan., 4 Jan, etc...? Any way to do ?

Any suggestions would be most appreciated.

Regards,
Bob

  #2   Report Post  
Old February 5th 18, 12:13 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,570
Default Plotting Data When There Is A "Jump" or Transition To Jan. Of New Year ?

Hi Bob,

Am Mon, 5 Feb 2018 02:36:08 -0800 (PST) schrieb Robert11:

Using the latest Excel. Probably should have stayed with Excel 2007, as it handled this without any problem.

I have a simple spreadsheet for my blood pressure.
Dates in one column, and the Systolic and Diastolic values in the next two columns.

The Dates I use in the data table are e.g., 15 Dec., 22 Dec.,
and then we go to: 4 Jan...etc.

Plots up fine as ling as there is no jump to Jan dates from the preceding Dec.
It doesn't know how to handle this transition, even though all the data is sequential.


format your x axis as text axis.
If that wouldn't help send your workbook to my email address and tell me
how many days or month you will show with your chart.


Regards
Claus B.
--
Windows10
Office 2016
  #3   Report Post  
Old February 5th 18, 03:07 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2018
Posts: 4
Default Plotting Data When There Is A "Jump" or Transition To Jan. Of NewYear ?



Hi Claus,

As always, thanks so much for help.

Good idea, I never would have thought of it, but:

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

I seem to remember reading way back a number of years that Excel
counts dates numerically from the start of the Universe, or
sometime close to it !

Thoughts ?

Regards,
Bob
==================================

On Monday, February 5, 2018 at 5:36:09 AM UTC-5, Robert11 wrote:
Hi,

Using the latest Excel. Probably should have stayed with Excel 2007, as it handled this without any problem.

I have a simple spreadsheet for my blood pressure.
Dates in one column, and the Systolic and Diastolic values in the next two columns.

The Dates I use in the data table are e.g., 15 Dec., 22 Dec.,
and then we go to: 4 Jan...etc.

Plots up fine as ling as there is no jump to Jan dates from the preceding Dec.
It doesn't know how to handle this transition, even though all the data is sequential.


For dates, I used the format like 24 May, 10 June, etc. on
the X Axis (and for the data values).

Plots fine up until 31 Dec.

The X Axis does show Dec. and Jan Labeling.
But if the Selected Data includes Jan, then the plot/graph turns blank.


Obviously it isn't sure if this Jan should be at the beginning of the table or here, at the end.
Apparently, it gets confused on how to handle, and does nothing.

Excel 2007 handled it fine.

You would think with everything being sequential, it would handle the transition from 23 Dec to 2 Jan., but it won't.

Really don't want to have to use the date formatting where the year is included, but may have to.

Thoughts on plotting data with this year transition in the format I
would really like as 27 Jan., 4 Jan, etc...? Any way to do ?

Any suggestions would be most appreciated.

Regards,
Bob


  #4   Report Post  
Old February 5th 18, 03:25 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,570
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
  #5   Report Post  
Old February 6th 18, 11:56 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2018
Posts: 4
Default Plotting Data When There Is A "Jump" or Transition To Jan. Of NewYear ?

Hi Claus,

Again, thanks for all the time you are taking in helping me out with this.
Really nice of you.

Would be happy to send you my Workbook.

How do I do it, please ?

An individual eMail (outside of this Forum) direct to you with an Attachment of
the Excel Spreadsheet ?

Or,...?

Bob


  #6   Report Post  
Old February 6th 18, 12:02 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,570
Default Plotting Data When There Is A "Jump" or Transition To Jan. Of New Year ?

Hi Bob,

Am Tue, 6 Feb 2018 02:56:49 -0800 (PST) schrieb Robert11:

Would be happy to send you my Workbook.

How do I do it, please ?


send it to


Regards
Claus B.
--
Windows10
Office 2016
  #7   Report Post  
Old February 6th 18, 07:46 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2018
Posts: 4
Default Plotting Data When There Is A "Jump" or Transition To Jan. Of NewYear ?

Hi Claus,

Tried a few times now, but can't get the email to go thru to you.

Problem is, apparently, my decoding of the dummy characters, etc. in your email address.

Might you send me an email with the exact, correct, eMail ?

Mine is:

Thanks,
Bob.


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
Creating a search and "jump to" function Brisebear Excel Discussion (Misc queries) 3 August 21st 06 02:07 AM
Make typing "jump" to matching item(s) in drop-down list? Kathy Excel Discussion (Misc queries) 4 November 22nd 05 11:25 PM
Use "Paste Link" info in a cell to Jump to source? Wayne Excel Programming 1 February 27th 05 04:59 AM
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc Bob Reynolds[_2_] Excel Programming 0 March 4th 04 09:52 PM


All times are GMT +1. The time now is 06:14 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017