Hi,
I'm in need of some help in creating a spreadsheet and graph for my business. I haven't used Excel since I left school so I'm a little bit rusty, but I'm a fast learner.
I work in a pub with a large beer garden. I want to create a spreadsheet and line graph that show the relationship between the weather and the pub's revenue, i.e. one line for revenue and one line for the temperature. I'm going to focus on the two busiest days of the week: Saturdays and Sundays.
I would like to create a line graph that has the date on the x-axis, the day's takings and the average daily temperature on the y-axis and some symbols denoting the day's weather (e.g. a cloud, a sun, a raindrop, etc.) running along the top of the graph parallel to the x-axis.
Does this sound feasible? How would I go about creating this spreadsheet and graph?
I'm in need of some help in creating a spreadsheet and graph for my business. I haven't used Excel since I left school so I'm a little bit rusty, but I'm a fast learner.
I work in a pub with a large beer garden. I want to create a spreadsheet and line graph that show the relationship between the weather and the pub's revenue, i.e. one line for revenue and one line for the temperature. I'm going to focus on the two busiest days of the week: Saturdays and Sundays.
I would like to create a line graph that has the date on the x-axis, the day's takings and the average daily temperature on the y-axis and some symbols denoting the day's weather (e.g. a cloud, a sun, a raindrop, etc.) running along the top of the graph parallel to the x-axis.
Does this sound feasible? How would I go about creating this spreadsheet and graph?
