It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Plugin Jira cloud for excel


I'm using the JIRA.JQL function but it is bringing unnecessary information on the first two lines, such as the time that was imported and the number of rows, this harms to generate graphics because I can not use the column header, help me?


Erro plugin.PNG

1 answer

0 votes

Hi @Ricardo Plens , 

I think you can ignore the first 2 rows when generating graphs. 

Let me know if the following works for you:

- Select all columns and insert a graph

- Right click on the graph and select "Select data source"

- Change the series values to start from the third row, e.g. change =Sheet1!$K$1:$K$282 to =Sheet1!$K$3:$K$282. Do the same for the Horizontal axis labels. 

This should make the graph only take into account data from the third row (where the Jira data starts).

Alternatively, you could select the table manually (click and drag) before you generate the graph.

Would that work?

Hello @Tanguy Crusson 

I do not use excel to generate graphs but Power BI, so I use excel only as a database to update the information in real time, I will try to find some alternative within Power BI, anyway thank you for your help.

Like Tanguy Crusson likes this

Suggest an answer

Log in or Sign up to answer

Community Events

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

Events near you