Skip to content

Exporting Historgram to Excel

Austin RobinsonMember for 8 years
Created
2
3
0

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

2 replies

Oldest first
  1. 0
    Mike Testro ·

    Hi Austin Welcome to Planning

    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

  2. 0
    Chris Wilson ·

    I have exported data using

    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

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?