I'll start with my customary advanced "thank you" for even looking at this and for all the posts that have helped me...ever. Thanks to this forum, I've become quite handy with Excel formulas, but I'm still really shaky on charts.
A little background on the spreadsheet: I have a spreadsheet that I have setup to have raw data pasted into. Long story short, it pulls the maximum reading for a given 5 minute period and returns the highest value for each 5 minute increment where there was a reading. It does this for all of the different dates entered, returning a separate data table for each date.
What I now need is to graph the data on a line chart. Since the number of time values can be variable, I have to include the entire range (for example A3:B5002). When I graph this out, it has all of the data clumped up at the beginning and flatlines for 99% of the chart.
I tried building dynamic named ranges using offset, but that seems to yield similar results once charted.
See the link below where I've dumped some sample data in (it wouldn't let me upload due to the size and I can't upload only part of it without breaking the whole thing). The data I need to chart is from columns A&B on the GraphData sheet. Sheet 1 contains the chart I have been trying to use. The endgame of this is to have the end user paste in their data and *POOF* charts.
Any help would be most appreciated. My only restriction is that I cannot have Macros/VBA.
https://drive.google.com/file/d/0B3a...it?usp=sharing
EDIT: I tried following the this post and using NA() instead of ""...no dice, it just puts #NA at the bottom labels instead of spaces.
Bookmarks