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

2 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?

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Marketplace Apps

Tips on how to choose the best estimation method for your planning

Planning and grooming sessions all come with their own sets of rules. Team members meet to estimate stories or other work items, all according to an agreed-upon process. And with every session comes ...

72 views 0 11
Read article

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