Simple line chart in Office 365

Harry32

George
Thread Starter
Joined
Jul 28, 2009
Messages
168
Last August I created a simple line chart in Excel to plot the end-of-month values for some numbers I’d been recording since12/31/07. It was easy to do; I was working in Excel 2010 at the time, and the chart line extended correctly each time that values were added through the end of the year.

However, in early Jan 2021, I upgraded from Ofc 2010 to MS 365 and found that the
chart line no longer extends when 2021 values are added to the data table.

So I created a new chart in Excel 365 using the same 2-column data table (Col 1 being month-end dates & Col 2 being values for each date. After many hours of struggling to find needed edit commands, I managed to produce an Ofc 365 chart that looks like the Ofc 2010 chart except for one item that defies attempts to correct:

Major gridlines on the horizontal axis are correctly placed at the end of each year but are labeled as 12/1 of each year instead of 12/31 of each year.
How can I correct this to agree with the data series for the horizontal axis? That series correctly lists dates for the end of each month.

Tech Support Guy System Info Utility version 1.0.0.9
OS Version: Microsoft Windows 10 Pro, 64 bit, Build 19041, Installed 20200729221124.000000-480
Processor: Intel(R) Core(TM) i5-4690T CPU @ 2.50GHz, Intel64 Family 6 Model 60 Stepping 3, CPU Count: 4
Total Physical RAM: 8 GB
Graphics Card: Intel(R) HD Graphics 4600, 1024 MB
Hard Drives: C: 915 GB (801 GB Free); D: 15 GB (1 GB Free); E: 0 GB (0 GB Free);
Motherboard: Hewlett-Packard 2B0D, ver A01, s/n 2MD5270KS1
System: AMI, ver HPQOEM - 1072009, s/n 2MD5270KS1
Antivirus: Norton 360, Enabled and Updated
 

Harry32

George
Thread Starter
Joined
Jul 28, 2009
Messages
168
The chart updates correctly when new data is added. That is not a problem. And if I click on the intersection between the plot line and any one of the vertical gridlines (spaced 12 months apart over a period of 14 years), that data point displays the correct information, for both the date (12/31/**) and its associated value. But the label on the horizontal axis for that gridline is 12/1/** instead of 12/31/**. That’s the only thing that needs correction.

If Excel 365 can’t handle this, it doesn’t speak well for 365. Excel 2010 had no trouble with it.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top