Exporting Historgram to Excel

Hello all, could someone please help me get my histograms exported to an excel document? I am confused as to how this process works exactly. I've created a monthly costs and project s curve histograms. I need these to be exported to an excel document so they can stand alone from the project schedule pages. When I go to export them it asks for a template. This is where i get stuck. I do not know where to get a template or what it exactly it requires it for. If anyone could be of assitance it would be greatly appreciated.

 

Regards,

Austin

C
Chris Wilson 👤 Member for 9 years 7 months

I have exported data using the histonochart template this however gives me the rsource or cost item in the columns and the date/ alocation in rows. Does anyone know how to transpose this data before it is in excel so that the dates are the columns and resource/ cost allocaton are the rows?

 

Regards

Chris

M
Mike Testro 👤 Member for 20 years 5 months

Hi Austin Welcome to Planning Planet

If you right click the histogram and at the bottom there is Export to Excell.

You then have a choice of templates.

If you just want the data then select histnochart.xlt.

Other templates will generate the data and the chart.

Best regards

Mike Testro

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts