I want to export my dashboard to excel. I performed the following steps but not able to export the data in Excel:
1. Right clicked on Dashboard; selected Export to Microsoft Excel.
2. Web Query box appeared, saved the query.
3. Now whrn I am trying to open the Microsoft Office Excel Web Query File in Excel it says caanot download the data.
Can anyone help me with this or provide me any other solution to export Dashboard to Excel.
Thanks in advane.
Although your question is quite confusing, these may be answers for you:
You can export a dashboard to PDF as written in this tutorial. Note: this is about exporting dashboards (also including chart-type gadgets), not about exporting the issues from Issue Navigator.
It looks like this:
jira-dashboard-pdf.png
First, Excel may not be the best format to export JIRA dashboards to, as the charts in JIRA are rasterized images (or SVG), not the same representation used by Excel.
If you want to re-produce the charts in Excel, use the Better Excel Plugin. It allows to export JIRA issues, and create any chart from the named range that encompasses the issue list! See this tutorial.
It is actually super-powerful and looks like this:
excel-chart-result.png
Hi, did you set the Issue Navigator as your home page instead of the normal gadget Dashboard? Can you let us know which version of Excel you are using? It's definitely worked for me.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Excel 2003 has worked for us. Hi and what browser you are using? You can only export the list of issues with either all your fields or your currently configured fields. Then you may create a chart/graph from the excel itself, but you cannot export it as a predefined graph.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ah, good point. If they are not talking about the dashboard at all, and using the issue navigator, then it is an option (hence my three attempts to get them to answer the question "where are you clicking").
This function is prone to networking problems, and only more recent browsers and spreadsheets support it properly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am using Excel 2003. I want to Export my Dashboard only with the Graph view. Is it possible??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I don't understand this. There is no "export to excel" option on dashboards so you need to explain where that is coming from first...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
When I right click on Dashboard there I can see Export to Microsoft Excel. It creates a Excel Web Query file. When I am trying to open it, its says Getting Data and then an error message appears.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, I wasn't clear.
None of the systems I use have "export to excel" when I right-click on Dashboard.
Where are you getting this function from? It sounds like a browser plugin of some sort to me, so you'll need to explain that. Tell us EXACTLY where you are clicking - what Jira screen are you on and which bit you are clicking. What other options do you get?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am on JIRA Dashboard page. When a right click my mouse, along with Print, Print preview I get this option Export to Microsoft Excel.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Still sounding like a browser function to me, especially with "print" appearing (what are the other options there?). Which browser is it? Can you try another browser?
I certainly don't get an excel export option when right clicking. I am now 99.99% sure that it's something in your browser and not Jira. You'll probably need to fix whatever is providing that.
and again,
Tell us EXACTLY where you are clicking - what Jira screen are you on and which bit you are clicking.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.