I have a Table with the first header column with the months of the year. The first header row has the years: 2015, 2016… Is there a convenient way to plot the cell values in a single line graph starting with January 2015 to the end of 2017. To recap. One header column with the months and one header row with the year. So there would be 36 elements to plot.
Thanks in advance.
—–
Gene
If you want the graph to be time along one axis and values along another, you need to put each record into its own row.
So copy and paste and do what you need to do so you have 36 rows, each with a date in one column and then a value in the other column, Then select those columns and make your graph.