Multi-Row Sequential Data

[jboyle923]

Hi guys,

I'm analyzing unemployment rate data issued by the Bureau of Labor Statistics, which is attached and may be found here. For ease of use, I'd like to know of a simple way to create a line graph, which will sequentially plot the historical data, without having to create a single row or column for every data point. The solution will aid me greatly as most BLS data is issued in similar format. Thank you!

Regards,

John

SeriesReport-20140622010348.xlsx

[rcm]

This is the only way I know how to get the correct type of graph... it adjust itself to the data. I chose to do it in a copy sheet named WS

Please Login or Register  to view this content.

[jboyle923]

This is the only way I know how to get the correct type of graph... it adjust itself to the data. I chose to do it in a copy sheet named WS

I've just found an Excel add-in, created by the St. Louis Federal Reserve Bank, which resolves my specific issue. It may be found here if anyone is interested. Thanks for your help, rcm.