Date and Time Charts
Hi All
Can anyone advise how I can plot Date, Time and Amount. For example, I have a student who has seizures and these can be daily. So we need to monitor her so that we can advise the doctor on the status of her health each week. Therefore we need to plot the date - say 15 June 2009, the time - say 11.54am and 14:20pm thereby making the frequency 2 times. What sort of graph would plot this information?
Help
Thanks
You can build a pivot table/chart on just that data.
The attached contains named range, PT_DATA, that will auto expand as more data in added in column A.
If you select the pivot table and Refresh the data source the chart and table will update with the new information.
Hi Andy
Thanks for your suggestion of a Pivot Table. As you can see from my attachment, I have tried that. What I really want is a chart to reflect the frequency of the seizures. If you look at my attachment, the chart I have plotted doesn't even put the time or date where I want it to go. I would like the time on the left hand side axis and the date on the bottom, showing the frequency as the data - thanks so much for your help.
Take a look at the attached.
I'm not clear on how you want to see it, so I showed it two different ways.
The first one shows you just a count per day regardless of time (which I'm thinking works well in the chart).
The second one shows details the time for you (which I'm thinking works well for the table, if the doctor needs to see the details by the time).
The first one is going to be the one that gives you a quick overview of the count per day.
I have added a line to show you what it will look like with 2 on the same day.
Hope attach files will solve the matters. I'm not an expert in Pivot Chart but I do experiment in manual charts ....... A simple approach i've shown you in Bar "Simple Solution" Tab ....... By the use of Auto Filter you can make charts as well as there is option in Tools>Chart > Visible Cell Only .... so when in Auto Filter you will select non-blank cells then automatically chart will hide the gapes .....
If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.
The problem with your requirement is that unless you have a record with a seizure at exactly the same time, which I assume is impossible, you will only ever have a frequency of 1 when the records is examined at the level of day/time. In which case mubashir aziz's Line chart will display each seizure with date on the X axis and time on the Y.
You might want to remove the actual line as data markers alone are more appropriate.
If you want to show frequency of seizures in a greater time-frame, such as per day or per week, then use the PT to group and count the records. Displaying the information in a column chart.
Re: Date and Time Charts
hello there, thank you very much for your prompt response to my post. I'm leaning more towards your copy of sample solution bar excel spreadsheet. I'm looking at Solution-manual worksheet. I'm trying to duplicate the chart you have produced on this worksheet. Could you kindly give me step by steps for this so that I can product a chart that reflects what you have? I would be ever so grateful. ThanksOriginally Posted by mubashir aziz
I"ll guide you from my sheet and Data in Sheet "Solution-Manual"
You Chart is there
- Select the Area from A1:B13
- Click Chart Wizard from tool bar
- Select Line Chart (Line with Marker) & Press Next
- Now Select Series Tab
- Remove Date Series
- Now go in Category (x) axis label and Select range A2:A13, Next
- Next & Finish
Another Choice if you don't want to use Auto Filter
- Your chart will be showing gapes for blank cell in time Column B
- Now select A1:B13 and put Auto Filter
- Now in B column Select non blank from Auto Filter
- Your chart will be changed accordingly and gapes will be vanished
If you need more clarifications, do let me know
- Select the Chart
- Now Go in Tools>Option > Chart
- Now Tick in Plot Empty Cells as: * Interpolated
- Gapes will be vanished
Wow - you are fantastic, a million thanks. Is there any way that I can show the time axis from 09:00 in the morning until 15:30 in the afternoon please, I would so appreciate that assistance. Thanks again.
U always welcome ... to restrict the y axis from 09:00 am to 03:30 pm just see the attached graphics ... Just select the Y axis and change in scale & Number format ......... but make sure you have time ranges between 09:00 ~ 15:30 as 16:00 hours will cross the axis ....
I've to go now, do let me know if you have any further query .......
Hi again - thanks for that - it helps. but in my original data, for example I have a date of 16 june and 22 June, etc. In the chart you have produced on the solution manual worksheet, these dates do not get shown on the bottom axis - can you explain this please. this is all I need now to get my chart underway. Thanks
Just doulbe click and X axis and see minimum & maximum in Scale tab ... may be these dates are less or more than 16-Jun ~ 22-June .......
bye,
thank you very much.
So you made it !!!! good
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks