How can I convert my 'Column' graph to a 'Line' graph

[Dimitri_Economidis]

I have a 2x13 table, the 1st column's header is 'Month' and the values in the column are the months from Jan to Dec, the second column's header is 'Sales' and there are numerical values in the rest of it. Using the ‘Chart from Table’ macro, I can see a 'Column' graph (as well as a 'Donut' graph) but I want to see my chart as a 'Line' graph and this doesn't work, I get the message 'Probably, there is no data in the Values column. Please, select the column with data values for chart generation'.

Any ideas?

[Andrey Khaneev _StiltSoft_ · Accepted solution]

Hi Dimitri,

Please, select the Time Line type instead of the Line type and set the date format to M:

[Dimitri_Economidis]

Thanks so much, works like a charm :)