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

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

3 answers

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.

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

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}

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.

In the macro body - use insert wiki markup from the insert pulldown

What version of Confluence are you using, Jagbir?

0 votes

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.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted 3 hours ago in Canada

TOPIC TUESDAY - Oct 16th - Fav Atlassian Logo

Hey folks, We are back with your Topic Tuesday Question for the week. This week we are asking what is your fav new Atlassian logo? My vote would be for Statuspage. Let us know your thoughts! &nbs...

15 views 2 0
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you