Quote:
Originally Posted by Sunny Rio
My chart is messed up. It's got an x axis of dates, almost every day over the last year has an entry. The y axis is a number from 1 to 4000. There are several data serieses.
If my x-axis is set to automatic, it makes a huge gap at both sides of the chart, going from far earlier to far later than the range of dates I've input.
So to work around this, I have to manually change the range to something sensible. Then I encounter a different problem - it needs me to input the date in what I presume is computerised date form, the number of days since 1900.
Does anyone know how to fix either of these two problems?
|
It actually starts where your data starts, 12/22/21, and ends at 12/30/22, just a little ahead of your last input date value.
I am seeing what you're seeing in adjusting the min and max axis values. The trick to figuring that out is to open Excel, type those two numbers in there (44552.0 and 44925.0) and then apply a date numeric style and you'll see they are 12/22/21 and 12/30/22. If you want to adjust your chart to start at say, March first, you can use Excel to convert that date to a number value (44621) and plug that in.
That said, as Guessed mentioned, this whole process is just easier in Excel, especially with something with as many values as you have. Also, you set your top cutoff at 3500, but you have values that go over 30,000 in the early part of your chart which aren't going to show up.
Dates as an axis in either program are going to be processed, by default, in whichever way they are going to chunk up best. I plopped your data into Excel, and it defaults to labeling by month, which may not correspond to your exact dates. In Excel there's an easy adjustment to the axis where you can change it to a "text axis" - at least in 365 which is what I have. I can remember in old versions having to put an apostrophe in front of the number to get Excel to treat the date label as text.
You also had a row of data below your date-labeled rows that was much smaller in value. I removed that for the Excel mock-up attached.