8thwondurrrr
New Member
- Joined
- Sep 22, 2015
- Messages
- 13
I have a Membership tracker in excel where member can log in and excel logs their names (Column A), Daily Fee (Column B), Time in & Time out (Column C&D), and then totals for Hourly Total, & Fees Owed.
I want to create some kind of to illustrate when people are coming and going. I am having a Hard time with the Horizontal Axis (log In Time) reading someone logs in, & then the corresponding bar starting when the log in and stopping when they log out in relation to the event duration.
I am having a bunch of problems, the X Axis is reading from 01/0/00 as opposed to game start, and reads until 2036. The Format doesn't have an option to reference a cell to start x axis at and end x axis at.
I am thinking a gannt chart would work the best but I can't format the chart there. Any Ideas?
I want to create some kind of to illustrate when people are coming and going. I am having a Hard time with the Horizontal Axis (log In Time) reading someone logs in, & then the corresponding bar starting when the log in and stopping when they log out in relation to the event duration.
I am having a bunch of problems, the X Axis is reading from 01/0/00 as opposed to game start, and reads until 2036. The Format doesn't have an option to reference a cell to start x axis at and end x axis at.
I am thinking a gannt chart would work the best but I can't format the chart there. Any Ideas?