View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Kirsten Kirsten is offline
external usenet poster
 
Posts: 7
Default Large Quantity of Data, Graphed in Time Intervals

Thanks! Do I have to group the data in time intervals in separate columns or
can I somehow sort them using only the 1 minute intervals?

-Kirsten

"Jon Peltier" wrote:

You can use a pivot table to group times by such intervals.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"Kirsten" wrote in message
...
I have a very large set of data (over 20,000 points) listed in minute
intervals. I'd like to be able to create charts using different time
intervals such as 5 minutes, 15 minutes etc. by using a pull down menu to
select the interval and have the graph make itself. Is this possible?