nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Brett Bullman

Soruce data.PNG Date error.PNG Line Graph.PNG

All comments

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

Soruce data.PNG Date error.PNG Line Graph.PNG

Brett Bullman

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

Thanks

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?

New output.PNG New source.PNG

Katerina Kovriga {Stiltsoft}

Let me two minutes to recreate your table and advise.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

graph