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; } } }

How to import data from an excel attachment into a chart macro (Confluence 4.1)

Jagbir Singh

I have an axcel sheet which I have displayed using the Office Excel Plugin.

But I would also like to display a few charts on the same confluence page. For this purpose I would like to use the Chart Plugin as the charts from the excel sheet do not show up very well.

But I would like to use the data which I have in my exsiting attachment.

Is there a way to using the data from my excel attachment in my Chart Plugin?

Thanks

Sunny

Accepted answers

All comments

Renjith Pillai

If I am not wrong, we used to export the data into CSV from the excel and directly use the chart macro with data as csv.

Jagbir Singh

could you please mention the steps or some link which explains how to do that?

Bob Swift

The chart plugin just needs a table (in the right format for the chart type) in the macro body to work. Both the excel and csv macro produce this. The outline of what you can do is:

{chart:...}
{excel:...}
{chart}

or 

{chart:...}
{csv:...
{csv}
{chart}

Jagbir Singh

Thanks for the reply Bob. Sorry i am a little confused. When i try to in the use the chart plugin i have to fill in a whole bunch of fields in plugin edit section. so where exactly do i mention what you wrote above. i would be grateful if you could explain using an example.

Matt

What version of Confluence are you using, Jagbir?

Cole Parsons

From googling around myself I have found this solution:

You'https://bobswift.atlassian.net/wiki/spaces/TBL/pages/67830715/Converting+CSV+Data+into+Tables

you'll wanna export a .csv file from your excel document and paste it into a macro like shown in the link and that should work.

Welcome!

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

Quick Links

Find more posts tagged with

confluence

app

ms-excel

data

chart