O
overgaard92
Hi. I am trying to create a stacked bar chart from data that has dates as its
values. I need the dates to be values because they will be calculated based
on certain conditions. Specifically, I am creating a vaccine scheduler for
nurses to use to determine a child's date ranges for receiving individual
innoculations in each vaccine series as calculated from the childs date of
birth and what innoculations they have already received.
I would like my x-axis to be a dates, my y-axis to be vaccines (e.g. MMR,
Polio, etc.), and the bars would show the range of dates for which an
innoculum in the series could be given. My problem is that when I create a
chart, the x-axis shows dates that begin at 0 (jan 1 1900) and go to 50000 or
something. Furthermore, the positions of the bars bear no relationship to
the dates on the x-axis.
I have tried to find a solution at peltiertech.com/ but have not had any
luck. An example of such a chart seems to appear at
http://peltiertech.com/Excel/Charts/FloatingColumns.html as the sixth chart
on the page (minus the Grantt stuff), also at
www.cdc.gov/vaccines/recs/schedules/downloads/child/2009/09_0-6yrs_schedule_pr.pdf
I hope I have been clear. Pardon any ignorace I have shown, I am not an
experienced excel user.
values. I need the dates to be values because they will be calculated based
on certain conditions. Specifically, I am creating a vaccine scheduler for
nurses to use to determine a child's date ranges for receiving individual
innoculations in each vaccine series as calculated from the childs date of
birth and what innoculations they have already received.
I would like my x-axis to be a dates, my y-axis to be vaccines (e.g. MMR,
Polio, etc.), and the bars would show the range of dates for which an
innoculum in the series could be given. My problem is that when I create a
chart, the x-axis shows dates that begin at 0 (jan 1 1900) and go to 50000 or
something. Furthermore, the positions of the bars bear no relationship to
the dates on the x-axis.
I have tried to find a solution at peltiertech.com/ but have not had any
luck. An example of such a chart seems to appear at
http://peltiertech.com/Excel/Charts/FloatingColumns.html as the sixth chart
on the page (minus the Grantt stuff), also at
www.cdc.gov/vaccines/recs/schedules/downloads/child/2009/09_0-6yrs_schedule_pr.pdf
I hope I have been clear. Pardon any ignorace I have shown, I am not an
experienced excel user.