All the columns have headers, but I've learned you can't use them in graphs unless you they are consistent with the colums' cells content. The (line) graph will try to graph the header as data. You have to use row 2 to the end for the graph. I also learned the graph won't properly read custom date formats but uses the row number instead of the data, eg. when I use jan 05 instead of the available default 05-Jan. Why MM DD isn't a choice format escapes me.
I'm plotting 366 days of 3-5 columns of data, which are statistics about the 26 years of data for a snotel site operated by the NRCS. When I added the stat columns at the end of the table with the 26 years of data in between the date and stats, the graphing package wouldn't use the stats column header or allow me to edit the name. It read it from the table correctly (shown in the dropdown menu), but the graph ignored it.
When I removed the columns of year data, the graph worked fine reading the headers for the graph and I could edit. it. It did the same when I tried to plot individual years with the stats, not recognizing the header until I deleted the hidden columns. That's why I created 26 separate files for each year duplicating the stats so it would graph correctly.
As for your questions, 1.- header row; 2.- after; 3.- line chart; 4.- I don't know, but I found work-around solutions.
I've also found when working with some graphs, the program seems excuriatingly slow, waiting 3-5 seconds for it to do something when I click or type, and even 5-15 seconds for some changes, even when it's the only application running on a G5 with 4.5 Mbytes of memory. My comment about that in another post was edited by the moderator. Although heartfelt from the frustration, it was inappropriate but not offensive. And I won't begin to discuss the PDF export function, beside the obvious, it needs some work.
