C
Conan Kelly
AAAAAAAAAAAAHHHHHHHHHHHHHHHHH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
THIS IS DRIVING ME CRAZY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I have this buggy chart. I have a spread sheet that I'm using to keep track
of my electric bill history. I have a Date column (statement/bill date), a
Month column (formula driven on the Date column), a Year Column, and a
Current Charges column (along with a lot of other detail columns). I have
the Auto Filter turned on and I use the Month and Year columns for
filtering.
I am trying to chart the Total Monthly Amount (Current Charges) by months on
a basic Column Chart. I can show the whole history on the chart, or I can
chart all months in one year, or one month in all years by using the
filtering described above.
The problem I'm having is when ever Sept '03 is showing on the chart, the
chart is not drawn correctly: instead of columns in my column chart for the
amount, I get a very thin line and the time series on the x-axis is screwy.
By filtering through the years, the '02, '04, and '05 charts are perfect
(columns, time series on the x-axis, and even the labels on the x-axis); '03
is as described above. By filtering through the months, all months are
perfect (columns, time series, and labels); September is kind of screwy as
described earlier, but I actually have columns this time, although my time
series is screwy: instead of getting only three units (three tick-marks) on
my x-axis (like I get with all of my other months), I get 25 units with
values in only three of them (the first one, the last one, and the middle
one).
When I first created this file a year or two ago, I think Sept '03 was the
last month I stopped at, and I didn't touch it again until this last
weekend. Also, I didn't have the Sept '03 electric bill, so some of the
amounts were estimated with formulas. But I have tried replacing the
formulas with values (no difference) and I tried deleting the whole row
containing 9-03 (no difference--except that 9-03 was no longer in there to
graph). Any help with this would be greatly appreciated. Hopefully we can
fix this w/o me having recreating the whole file and reentering the data.
I'm using Office XP (Excel 2002) with Win XP Pro (incase that helps). If
anyone wants the file to mess with, I am willing to attach it to a
post/email.
Thanks for any help anyone can provide,
Conan Kelly
ps. Just sitting here thinking about things while I'm writing this, I'm
certain that Excel has been updated several times (and probably with one or
two major updates) between when I created it a couple years ago and when I
got back into it last weekend. I'm wondering if the updates could be
causing the screwyness.
THIS IS DRIVING ME CRAZY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I have this buggy chart. I have a spread sheet that I'm using to keep track
of my electric bill history. I have a Date column (statement/bill date), a
Month column (formula driven on the Date column), a Year Column, and a
Current Charges column (along with a lot of other detail columns). I have
the Auto Filter turned on and I use the Month and Year columns for
filtering.
I am trying to chart the Total Monthly Amount (Current Charges) by months on
a basic Column Chart. I can show the whole history on the chart, or I can
chart all months in one year, or one month in all years by using the
filtering described above.
The problem I'm having is when ever Sept '03 is showing on the chart, the
chart is not drawn correctly: instead of columns in my column chart for the
amount, I get a very thin line and the time series on the x-axis is screwy.
By filtering through the years, the '02, '04, and '05 charts are perfect
(columns, time series on the x-axis, and even the labels on the x-axis); '03
is as described above. By filtering through the months, all months are
perfect (columns, time series, and labels); September is kind of screwy as
described earlier, but I actually have columns this time, although my time
series is screwy: instead of getting only three units (three tick-marks) on
my x-axis (like I get with all of my other months), I get 25 units with
values in only three of them (the first one, the last one, and the middle
one).
When I first created this file a year or two ago, I think Sept '03 was the
last month I stopped at, and I didn't touch it again until this last
weekend. Also, I didn't have the Sept '03 electric bill, so some of the
amounts were estimated with formulas. But I have tried replacing the
formulas with values (no difference) and I tried deleting the whole row
containing 9-03 (no difference--except that 9-03 was no longer in there to
graph). Any help with this would be greatly appreciated. Hopefully we can
fix this w/o me having recreating the whole file and reentering the data.
I'm using Office XP (Excel 2002) with Win XP Pro (incase that helps). If
anyone wants the file to mess with, I am willing to attach it to a
post/email.
Thanks for any help anyone can provide,
Conan Kelly
ps. Just sitting here thinking about things while I'm writing this, I'm
certain that Excel has been updated several times (and probably with one or
two major updates) between when I created it a couple years ago and when I
got back into it last weekend. I'm wondering if the updates could be
causing the screwyness.