Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
bar chart with dates on the x-axis
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/...ngColumns.html as the sixth chart on the page (minus the Grantt stuff), also at http://www.cdc.gov/vaccines/recs/sch...chedule_pr.pdf I hope I have been clear. Pardon any ignorace I have shown, I am not an experienced excel user. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
bar chart with dates on the x-axis
Excel 2007
Gantt Chart, multiple bars Variable X axis with dates http://www.mediafire.com/file/ywfity3mzyj/05_30_09.xlsx |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
bar chart with dates on the x-axis
Ah, thanks a lot. I think I can figure it out from there.
jdo "Herbert Seidenberg" wrote: Excel 2007 Gantt Chart, multiple bars Variable X axis with dates http://www.mediafire.com/file/ywfity3mzyj/05_30_09.xlsx |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
bar chart with dates on the x-axis
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...00906ACNJ.html _______ "overgaard92" wrote in message ... 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/...ngColumns.html as the sixth chart on the page (minus the Grantt stuff), also at http://www.cdc.gov/vaccines/recs/sch...chedule_pr.pdf I hope I have been clear. Pardon any ignorace I have shown, I am not an experienced excel user. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
bar chart with dates on the x-axis
Excel 2007
New, improved version. Update X axis and title with macro. http://www.mediafire.com/file/hzmdilmw2k1/05_30_09.xlsm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dates on scatter chart axis | Charts and Charting in Excel | |||
[in horz.bar+chart] Disply dates on value axis? | Charts and Charting in Excel | |||
Chart Dates on X Axis | Excel Discussion (Misc queries) | |||
Help with Dates on Y Axis of a chart | Charts and Charting in Excel | |||
Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) |