I am sure this is so easy but i just cant get it
i reports that go out every day for data the day before and i need to plot the time that data report has gone out
eg
Data Date Report 1
1/11/09 (2/11/09, 11:04)
2/11/09 (4/11/09, 11:35)
3/11/09 (4/11/09, 12:35)
happy for the data date to be the point lable
any help greatly recived
cheers
boris99
Hi Boris99
Your problem will be a lot easier to understand and solve if you supply a small data sample in a workbook. You can upload a file by clicking "Go Advanced" below and then the paper clip icon.
Make sure that your sample data has the same formatting and layout as your original, because in charting, a lot depends on the data!
cheers
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
have up loaded the sample data
i am sure this is so simple
can you describe what kind of chart you want? Line? Column? XY? I have no clue what you want to show.i need to plot the time that data report has gone out
Last edited by teylyn; 11-17-2009 at 06:42 AM.
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking the
You could plot the second series as xy-scatter and use X-error bar to provide a datum line for each column.
Afternoon
No thats not quite what i was expecting
I am looking for a graph with Date on X time on Y
it will have a solid line for the target
and then plot the individula report dates and if above the line bad ie deliverd late below the line good
as long as the day is right as well
hope this helps
cheers
Boris99
more like this then?
Afternoon
This is almost there
except the red target line should be at 11am
and each of the blu dots should be at the time they are related to
cheers
boris
Change the formula,
G7: =D7-(INT(C7)+1)
H7: =E7-(INT(C7)+1)
copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks