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:

Tags

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 PM.