Search results

I was able to recreate it by memory and came up with the same out come. Thanks again.

Hui, Thank you very much, I am learning a lot. Travis

Each location will be represented individually, If you dont mind explaining the methodology with the data below, which should be more realistic, and have a better looking line chart. Thank You Type Date Location 2 14 Mar 12 A 3 12 Mar 12 A 4 11 Mar 12 A 4 11 Mar 12 A 4 11 Mar 12 A 4 11...

Hui, They are all right on the money, Thank You, I will use the bottom left chart for my analysis. Will this work with a large data set? would you be able to explain the process? Travis

Thanks Hui, I look forward to gaining a better understanding on excel I should have been more clear. (Bar Graph) I need to represent the days (Date) into weeks, 7 day periods, for location A, then do this again for location B. Each seven day period will have as the Y axis the amount of...

Bar= Total activity per week Line= Total activity per week by type One location at a time. I assume I would first filter out the location I did not want, then I can create a pivot chart, or bar graph based on all the activity, but im lost after that, getting the line and the bar graphs on...

I am trying to identify a totals on activity over the past few years, by week, using a bar chart, followed by breaking that data out into compnants with the same axis but using a line chart. X = Each week for the past three years Y = The amount of activity Bar = Total Activity (in the...