Excel Graph automation
Budget: $30 – $250 AUD
Making an excel graph based on changing data.
I Have attached the excel file I need help with (time graph 1208.xlsm)
I have attached a word doc we produce from the date in the spreadsheet (week end 0608)
I have already made the spreadsheet but I need help with the Graph and getting it the correct size
Each day we write in drink times each half an hour.
We only currently are tracking 3 days (Thu, Sat & Sun)
All days have different starting opening/closing times
Thu 5pm-9pm
Sat 10am-5pm
Sun 11am - 5pm
The date & data is entered on sheet "30 Minute Times"
The graph is produced on sheet "Graph"
We use the screenshot button to take a picture of the graph.
I need the graph only to display the times for the day (see above Thu,Sat,Sun) as our problem is the graph bottom axis displays all the times that are not included. If we don't include them it still leaves it blank and squishes all the bar chart lines together.
To Reiterate:
-Enter sales times each half hour
-Create graph based on data
-Screenshot button needs to take a screenshot of a good full graph, not just squished in one side.
-Times change each day (See above), so a Thursday graph should only have 5pm-9pm. But a Saturday would have 10am - 5pm
-Graph shows green bars under 4 minutes and red bars for over 4 minutes.
The word doc shows the graphs all squished to either the left or right and showing all the times instead of just the times relevant to the day.
I Have attached the excel file I need help with (time graph 1208.xlsm)
I have attached a word doc we produce from the date in the spreadsheet (week end 0608)
I have already made the spreadsheet but I need help with the Graph and getting it the correct size
Each day we write in drink times each half an hour.
We only currently are tracking 3 days (Thu, Sat & Sun)
All days have different starting opening/closing times
Thu 5pm-9pm
Sat 10am-5pm
Sun 11am - 5pm
The date & data is entered on sheet "30 Minute Times"
The graph is produced on sheet "Graph"
We use the screenshot button to take a picture of the graph.
I need the graph only to display the times for the day (see above Thu,Sat,Sun) as our problem is the graph bottom axis displays all the times that are not included. If we don't include them it still leaves it blank and squishes all the bar chart lines together.
To Reiterate:
-Enter sales times each half hour
-Create graph based on data
-Screenshot button needs to take a screenshot of a good full graph, not just squished in one side.
-Times change each day (See above), so a Thursday graph should only have 5pm-9pm. But a Saturday would have 10am - 5pm
-Graph shows green bars under 4 minutes and red bars for over 4 minutes.
The word doc shows the graphs all squished to either the left or right and showing all the times instead of just the times relevant to the day.