Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a data set of dates, and counts of frequency.
There is a sample of the data below. I've made a bar graph that simple shows how many times each date shows up, but what i'd like to show now is a line graph to shows how many times a date occured and also the time between.. So for example in the below data set the 27th has no bearing on the graph because its not in the set. i'd like the 27th to be on my graph with a zero value essentially. I have a fairly large data set as is, i dont want to have to manually enter in dates. Also, if i look in the Select Data.... the Horizontal (Category) Axis Labels has each date that shows up. basically what im trying to do is change that from a data set to a date range... hope this is clear enough... Thanks Justin Sample Data 4/17/2009 4/21/2009 4/22/2009 4/23/2009 4/24/2009 4/25/2009 4/28/2009 4/29/2009 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line chart - time series - category axis date format (2007 VBA) | Charts and Charting in Excel | |||
Line Chart x - axis display date and quarter and automatically upd | Charts and Charting in Excel | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
how to show date on the x axis of a line chart? | Charts and Charting in Excel |