bar chart with dates on the x-axis

  • Thread starter Thread starter overgaard92
  • Start date Start date
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.
 
You should note that in a horizontal bar chart, the X axis is the vertical
axis, and it has the category names (the vaccine names), and the Y axis is
the horizontal axis, which plots values (i.e., dates).

The value axis (Y or horizontal) probably starts at zero (1-Jan-1900) and
goes to some large number, which is the number of days since 1-Jan-1900.
Today, 31 May 2009 is 39,964.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______
 
Back
Top