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

Problem to display right excel and charts macro?

Fred Erick

Hi,

I have added an excel speadsheet to Confluence with the Excel Macro.

Now I want to diplay a chart of that table:

Monate	Werte
Nov 19	242
Dez19	150
Jan20	192
Feb20	175

But it only shows this:

But I want a graph like this:

Bildschirmfoto 2020-07-02 um 14.30.27.png

My chart settings are:

Type: line

Allignement: vertical

Table:blank

Columne: 1,2

Strange thing, the bar chart is working:

What Am I doing wrong?

One more thing, I have some tables with filter, that changes the chart:

Bildschirmfoto 2020-07-02 um 14.59.18.png

Is that possible as well in Confluence with the nativ macros?

Accepted answers

All comments

Katerina Kovriga {Stiltsoft}

Hi @Fred Erick,

The Chart macro is not very flexible, so you'll need to rearrange your table in a horizontal way.

Fred 1.png Fred 2.png

And for the second question - there are no any native filtering tools in Confluence.

So we recommend to use our app - Table Filter and Charts for Confluence.

You'll be able to create tables from spreadsheets with the help of the Table from CSV macro and filter your tables using the Table Filter macro.

The app also contains the advanced Chart from Table macro, so you'll be able to create multiple charts based on filtered tables and pivots.

Fred Erick

Ok, that helps, is it possible with that app, to upload prefilled pivot tables and display them with the same filter without setting up these filter every time?

And display them in a chart?

Katerina Kovriga {Stiltsoft}

The Table from CSV macro works with the input that you've created. If you upload only prefiltered data and not the big source table, than you'll got the prefiltered result table in Confluence and you'll continue to work with it (create charts, set additional filters, etc.).

But the app was developed for users not to switch between Excel and Confluence. Our customers create big tables right in Confluence (manually or with the help of such macros as Jira Issues, Page Properties Report, etc.) or upload all the data in CSV format and set and save filters (both in the view and edit modes), create pivots, make calculations and build charts on Confluence pages.

You can play with the app on our demo server.

Fred Erick

I know, but I'm getting information from a database into an excel spreadsheet and need to build a dashboard with that information and I cant connect the database to Confluence.

Welcome!

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

Quick Links

Find more posts tagged with

confluence

new-to-confluence