Linked Excel Sheet Not displaying corectly on chart


Author
Message
Nevron Support
Nevron Support
Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)
Group: Administrators
Posts: 3.1K, Visits: 4.2K
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


Greg Corliss
Greg Corliss
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
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.

 

 


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search