I have added an excel speadsheet to Confluence with the Excel Macro.
Now I want to diplay a chart of that table:
But it only shows this:
But I want a graph like this:
My chart settings are:
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:
Is that possible as well in Confluence with the nativ macros?
Hi @Fred Erick,
The Chart macro is not very flexible, so you'll need to rearrange your table in a horizontal way.
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.
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.
I installed the try version but now I have some problems importing my xlsx file.
How can I import such a file with all its data?
Edit: I found out, when I use the Excel macro(native macro) and use my excel spreadsheet with it, now I see the charts of the spreadsheet in Confluence, is that because of your add on?
I've seen the file - it's a .xlsx file with several pivots, graphs and pages as well.
Our app allows you to upload raw information from the external database directly to Confluence - you'll get one big table from the source CSV file. All the filters and pivots are set in Confluence, you are not working with Excel at all.
If you still prefer to do all the manipulations in Excel and show only the result graphs to your colleagues, there is a workaround to save your Excel graphs as images and embed them on Confluence pages.
What concerns the native Excel macro, we haven't received any user reports about similar situations. The app is not related to any of out-of-the-box Confluence macros. I've also checked you case in our test environment (Confluence Server 7.5.0): I see the Excel charts both with the installed and deinstalled app.
Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events