Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hello to everybody !
I have this kind of data: TIME VALUE 0:00:00 0 0:00:34 1 0:00:35 1 0:01:00 0 0:01:30 0 0:01:33 1 0:01:55 1 0:01:59 0 0:02:00 0 0:02:10 1 0:02:15 1 0:03:00 0 0:03:05 0 0:03:07 1 0:03:55 1 0:08:00 0 and I need to create bar chart that would have a bar of the hight equal to 1 at each time value where the "value" in table (Y-axis) equals one (and also between "one"s values). In all other time values the Y value is zero ! Excel bar chart seems to omit all values that are not in the dataset ! I need to include also those time values that are not explicitly listed in the table - all those should be zero by default - e.g. 0:00:36 will be zero, 0:00:37 will also be zero until 0:01:33 where there will be again value of 1. Is it possible to make this kind of chart in Excel ? Thanks in advance Vlado |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line Chart | Charts and Charting in Excel | |||
Updating a chart automatically | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel |