Profile Picture

Linked Excel Sheet Not displaying corectly on chart

Posted By Greg Corliss 9 Years Ago
Author
Message
Greg Corliss
Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: Forum Members
Last Active: 20 Years Ago
Posts: 3, Visits: 1

I have an excel spreadsheet containing 53 weeks worth financial data. Dates & Currency.

When I map that to a line chart it displays only 6 weeks worth of data. If I change the X axis Range to display all data (putting in the date range) it shows the months but the data disappears.

The data spans from October to September but the Chart will only show data from the first week of January to the 2nd week of February.

It's Linear data starting at $0 and ending at $285,000

It's a simple line chart, I would think it would be fairly simple to build but its rather difficult. I can build the same thing in excel in seconds. I've been banging my head against the wall getting this to work correctly for hours. I'm ready to give up and go back to excel services charts.

 

 



Nevron Support
Posted 9 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,063 reputation)Supreme Being (4,063 reputation)Supreme Being (4,063 reputation)Supreme Being (4,063 reputation)Supreme Being (4,063 reputation)Supreme Being (4,063 reputation)Supreme Being (4,063 reputation)Supreme Being (4,063 reputation)Supreme Being (4,063 reputation)

Group: Forum Members
Last Active: 1 days ago @ 7:47 AM
Posts: 2,945, Visits: 3,303
Greg, most likely you have not configured the Pivot correctly.
Can you please send us a snapshot of the data that you use. Then we will be able to provide you with the correct chart configuration.

Best Regards,
Nevron Support Team





Similar Topics


Reading This Topic