Date axis screwed up when I increased the range in "select data"

		Microsoft Office Forums > Microsoft Excel > Excel
Date axis screwed up when I increased the range in "select data"

12-24-2022, 09:47 PM

Sunny Rio

Windows 11 Date axis screwed up when I increased the range in "select data"

Office 2021

Novice

Join Date: Aug 2022

Posts: 21

Date axis screwed up when I increased the range in "select data"

I had the chart working like this and could see in the x-axis, "bounds":

But the data was bigger than the chart, thus:

So I increased the data range 10 lines ahead to cater for increases in the future, thus:

But this resulted in chaos. The x-axis messed up, and I can't edit the bounds as they've disappeared(!), thus:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro	Matt C	Excel Programming	2	01-08-2022 06:03 AM
Intersect(Target, Sh.Range("AN4:AN5000")) can i reference this range another way?	trevorc	Excel Programming	2	04-30-2021 05:05 AM
Change the Column reference 'S' to a range ??? Sheets("Customer").Range("S" & ActiveCell.Row) = Date	trevorc	Excel Programming	1	03-04-2021 02:39 PM
Cannot "Select All" In Word Outline To Copy And Paste Paragraph Numbers	poolmon	Word	5	02-26-2021 06:59 AM
Date Axis on line chart includes dates with no data under them, but text axis causes data to clump	jcyo233	Excel	6	10-18-2018 04:49 AM