3 Replies Latest reply on May 11, 2016 10:30 AM by Shinichiro Murakami

# Projections vs Actual in a single line chart

Hi,

I am trying to plot total projections versus Actual in a single chart which contains 2 lines - one is for total projections and the other is for actuals.

But I am not able to do so because of the way the data is structured.

In the data, we have two different columns for projections and Actual. I want the X-axis to be independent of these to columns so that I can create calculated fields for projections and acutals based on the x- axis.

Is there a way to represent in a single chart. Sample workbook attached

PS: P01 - stands for Period 1 and so and so forth. My objective was to plot projections versus acutals against each period (P1 to P13)

Also I have manually added a 'Static Period' column so that I could calculate the projections and acutals based on this column and use this as a X-axis but I was unable to do so.

Thanks,

Dileep

• ###### 1. Re: Projections vs Actual in a single line chart

According to your input, seems like you need to reorganize data structure.

As you mentioned, Currently it's based on key fields of "Project" which has projected date and actual date.

What you need is "Period" as a key how many projected project and how many actual project.

To do that,

Duplicate data source.

Original one is for projection, and new one is for Actual

Rename both data source for recognition.

Under "Act" data source

Create calculated field

[Period]

[Actual Closure Period]

Under "Proj" data source

[Period]

[Projected Closure Period]

Rename "Number of Records" of both data source to

"act Count" and "Proj count"

Put fields as below.

Thanks.

Shin

9.0 attached.

1 of 1 people found this helpful
• ###### 2. Re: Projections vs Actual in a single line chart

Thank you so much Shin. This is what I needed

• ###### 3. Re: Projections vs Actual in a single line chart

You are welcome, this was little bit tricky situation .  good luck.

Shin