Excel Chart - Matrixed Data Source

[lneidorf]

Hi all.

I am struggling to create a basic line chart out of source data that is in a two-dimensional format. A sample will be easiest to understand:

_____|COL_A__|COL_B___|COL_C___|COL_D
ROW_1|_______|Jun-2013|Jul-2013|Aug-2013
ROW_2|Client1|12,502__|12,502__|12,502
ROW_3|Client2|7,362___|7,357___|7,357
ROW_4|Client3|4,657___|1,981___|2,337

(My apologies, but the MrExcel HTML Maker download link was broken.)

-In column A, there is a list of Client Names. Each Client Name should be a data series in my chart.
-In Row 1, there are Month-Year values. The Month-Years should appear along the horizontal X axis.
-The numerical quantities within the table should present as the vertical Y axis.

No matter what I try, Excel is using the Month-Years as individual data series, Client Names as the horizontal axis, and the quantities as the vertical axis.

Any help would be greatly appreciated!

Thanks.

 

[lneidorf]

And now I understand where I was going wrong: I was trying to use data that would have exceeded Excel's charting series limit of 250.