Forum Discussion
Inserting todays date
Thanks for the prompt reply.
I've already marked the "A" column as dates, and entered 5 sequential dates, none of which showed any inclination to automatically complete the dates. That's why I'm here.
Perhaps my Excel 2010 doesn't like the format 25/01/2020 ?
It seems happy to use my typed dates along the X-axis.
I've attached my xlsx file so you can have a good laugh at my expense!
Biography: I was never very good with spreadsheets, I was an IBM Mainframe system programmer when they became popular, so off my radar.
Now, whenever I try to use a spreadsheet it is as if every control, no matter how small, has an underlying meaning of "Destroy". I've been trying to make a chart from my data, and I've nearly rubbed the "K" (as in Control-K for undo) off my keyboard. I'll be asking a plethora of simple questions over the next few months. I've tried reading the help, but after a couple of steps I run into a step that's either not in my version, or just doesn't work.
Steve Swift Got it now. Confused myself in an earlier post (deleted). The attached workbook has your data in a structured table and both the table and chart should expand automatically when you drag down the date. "25-01-2020" will become "26-01-2020" and you'll see the X-axis "grow". Enter your new measurements and the lines will follow. Just yell is if it doesn't work for you.
Hello again, and thank you. I really appreciate your help, and your attachment.
I know all about confusion; I'm in my 70th year (I tell most people that I'm nearer to 60 than I am to 50... which is mathematically correct)
I got off onto the wrong foot when I read your most recent addition, because I was reading the Tech Community notification in my Gmail, which doesn't contain your attachment. Eventually I realised I had to view your post in the community.
I have a few small changes to make, but now I have your updated version I can fiddle about safely; I can always start again from your version.
Time for breakfast, if I can remember how to make the porridge!
- Incidentally, is there an Excel Community for novices?
I feel uncomfortable taking up the time of the experts.