Error displaying Chart Data from Excel source

Question

Hi, I'm having a weird error trying to display some chart data from an Excel source.

My markup is this

{chart:type=timeSeries|dateFormat=MM/yyyy|timePeriod=Month| dataOrientation=vertical}

{excel:file=MyFile.xls|columnTypes=D,I}
{chart}
The exact same data just placed in a table format within the chart macro does not produce this error at all.

Any ideas on how to fix this?

There is a reference to a bug in the old Chart Plugin https://studio.plugins.atlassian.com/browse/CHRT-77 but I can't find a bug listed in CONF since the chart macro has been taken over by Atlassian now.

Jodie Miners · Accepted Answer

Ignore me, it must have been something to do with an additional column in the data.

I now have

{chart:type=timeSeries|dataOrientation=vertical|dateFormat=MM-yyyy|timePeriod=Month|columns=1,2|domainaxisrotateticklabel=true|DateTickMarkPosition=start}
{excel:file=MyFile.xls}
{chart}

And it works fine