I am trying to create a line chart, please help

[Brett Bullman]

Hi There,

I am trying to create a line chart in confluence but it is just not working no matter what I try. 

Please see the excel line graph attached that I am trying to recreate. 

I have tried using both a confluence line graph and a time line graph but it just seems to not match the axis up and therefore the data is wrong. I also beleive there might be someting wrong with the date format but have tried them all.

Does anyone have a similar chart working?

Kind Regards,

Brett

[Brett Bullman · Accepted solution]

[Katerina Kovriga _Stiltsoft_]

Thanks, I see now - the error is in the date format.

Go to the macro settings -> Adjustments tab and set the correct format.

From your error I see that you have dd M yy that corresponds, for example, 21 Feb 2022.

As you use Feb-2022, then your format is M-yy.

[Brett Bullman]

@Katerina Kovriga _Stiltsoft_ 

So I tried using the date format MM yy which worked in the preview but didn't display anything when saved. So I changed all my dates to the default format it was asking for. This works but displays weeks on the x axis, I only want the dates I have entered in to be on the x axis. is there a way to change this? 

[Katerina Kovriga _Stiltsoft_]

Let me two minutes to recreate your table and advise.

[Brett Bullman]

I have now resolved this issue by defining the scale X step. Edit -> Adjustments -> Scale X Step -> Added 1m 

[Katerina Kovriga _Stiltsoft_]

The original date format works fine - you should change it not in the preview, but in the Adjustments tab of the macro settings.

Also it should be not MM yy (it corresponds to February 2022) but M-yy as I have mentioned before (it corresponds to the Feb-2022):

Don't choose the date format from the predefined options - type in the combination that suits your case! The predefined options do not cover all the possibilities, they just include the most common cases.

Your idea with the second step to adjust Xscale was right:

And here is the screenshot of the original table:

[Katerina Kovriga _Stiltsoft_]

Hi @Brett Bullman ,

Can't see your source table and an Excel chart.

What macro do you use? Is it the standard Chart macro or the Chart from Table macro provided by our Table Filter and Charts for Confluence app?

[Brett Bullman]

Hi Katerina,

Apologies, please see the source table attached. And this is using the Chart from Table macro. 

Thanks

[Katerina Kovriga _Stiltsoft_]

Still can't see the attachment - save your screenshots and upload them to the thread. Copy/pasting doesn't work here.

[Brett Bullman]

@Katerina Kovriga _Stiltsoft_  weird I was importing them. See above. 

Thanks