create hourly graph from half hour data

J

jacov

Joined
Jul 17, 2012
Messages
1
Reaction score
0
Hello,
i have an excel file with many rows
i need to create graph showing number of views per hour. i have half hour data. (accumulative views)
i used the functions in excel file to collate the hours. bet how can i create the graph if i have empty cells between.

also, can i create a graph showing average vies per hour for 2 weeks data?
thanks:thumb:
 

Attachments

  • Book1.zip
    13 KB · Views: 263

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot Add Error Bars for individual data points! 1
How do I add a trend line for only half of my graph? 1
Slow Excel graph with date axis 1
Averaging Hourly Data 2
Plot every other cell 2
I need to build a graph Chart 6
Graph to only include rows with data in 3
Excel 2007 - Printing graphs with no data or graph lines 1

Top