Having problems creating a graph

**cmf0106** · 09-02-2009, 04:28 PM

The data file should be attached. Without having to reformat the table I would like instructions on how to line graph this such that the month value is on the x axis and the consumer confidence index level is on the y axis.

Thank you so much.

**WHER** · 09-02-2009, 04:59 PM

Like this?

**cmf0106** · 09-02-2009, 06:59 PM

Sorry for not clarifying but it needs to be strictly one continuous line, not multiples. Hope that helps, thanks for the attempt though!

**shg** · 09-02-2009, 07:04 PM

Rearrange all the data into two columns with the complete date (month and year) in the left column, and plot in the normal fashion.

**cmf0106** · 09-02-2009, 08:05 PM

Thank you very much sir. Shame there was no way to do that without modifying it, but this is great none the less thanks again.

**shg** · 09-02-2009, 08:08 PM

You can do it with formulas.

In A37 and down, =DATE(INDEX($A$3:$A$35, INT( (ROWS(A$37:A37) + 11) / 12) ), MOD(ROWS(A$37:A37) - 1, 12) + 1, 1)

In B37 and down, =INDEX($A$2:$M$35, MATCH(YEAR(A37), $A$2:$A$35, 0), MATCH(TEXT(A37, "mmm"), $A$2:$M$2, 0) )