Search for content in message boards

Formatting charts, and exporting reports to Excel

Replies: 10

Re: Formatting charts, and exporting reports to Excel

Posted: 1353434253000
Classification: Query
Edited: 1353434744000
I can't help you with your first question.

But, as far as printing to Excel - when you export a report to Excel, some reports will ask if you want the export in rows or columns. If you say columns, names will be in rows and the other info in columns. If you say rows, the names will be in columns and the other info in rows. Other reports (like the outline descendant report) only export one way, but you can use Excel's columns to rows commands to turn the info "inside-out" and in reverse format)

To export a report to excel, with the report preview in front of you:

1) Click on the Share button in the upper right
2) Choose export csv
3) Choose rows or columns - if you get that screen.
4) You will be asked it you want to see the file - say yes
5) If it brings it up in Excel, used File > Save as to change the format from csv to excel.

You may have some cleaning up to do, the basic report is there.

SubjectAuthorDate Posted
Mavis_OConnor 1353430601000 
silverfox3280 1353434253000 
Mavis_OConnor 1353438459000 
silverfox3280 1353451446000 
Mavis_OConnor 1353452405000 
silverfox3280 1353464818000 
Mavis_OConnor 1353473900000 
Mavis_OConnor 1353474903000 
silverfox3280 1353508757000 
Mavis_OConnor 1353528942000 
per page

Find a board about a specific topic