Gates-speak
Last year I had a single Excel spreadsheet with three charts, each 26 items long; the number of characters in the alphabet.
I started a new spreadsheet with my first run this year. Now I had a second run, so could do a chart.
“Something is wrong,” I say. My chart is not identical to previous charts, and makes no sense.
“So use last year’s spreadsheet as a starting-point,” Linda suggests; “and then all your previous formatting is in place.”
Capital idea! I save last year’s spreadsheet as this year, and then delete the three rows of information.
First row is formatted as dates; then the second and third rows are custom-formatted as minutes and seconds and tenths of seconds, although it shows up as clock-time in the working window. (??????)
Third row is identical to the second row, as it’s the sum of the column — just the second row.
Now, chart-function. Chart contents of third row. It will be an up-and-down line.
“Not logical,” Excel asserts.
Okay; I determine that’s because no values are in columns selected but to the right of the two columns that have values.
Okay; insert zero as the total in each empty column.
Now we’re getting somewhere; I have a chart identical to last year’s chart.
But it wants to be chart #4. Charts 1 through 3 are still there.
So I need a “delete chart.”
I poke all around, but no “delete chart” function.
“I’m sure I did it once,” I say.
There is a “delete-sheet” function, but I don’t wanna delete the spreadsheet the charts work off of.
Do I call in the support of Excel-master, the guy who taught my Excel class?
I try the Excel “Help” function. Nothing about “delete chart.”
Finally, after taking a break and walking the dog, I decide it’s do-or-die time — time for a fearsome experiment. Just like the mighty Mezz.
I have on my screen the chart I wanna delete, and hit “delete-sheet.”
If this deletes my working sheet, I don’t save it. —And I still have the entire spreadsheet from last year I started with.
VIOLA; the suspect chart is gone, but my working spreadsheet is still there.
GATES-SPEAK ALERT! Apparently a sheet is also a chart.
I delete the other charts, so now I can rename “Chart-Four” as “Chart-One.”
How, pray tell, am I supposed to know the strange Gates lingo; that a chart is also a sheet?
Labels: 'pyooter ruminations
0 Comments:
Post a Comment
<< Home