The X axis is a date-scale axis? The axis min and max scale parameters
encompass the '=TODAY()' entries?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
All X-values are dates. Main chart data is column1=dates, as required
for
transactions (may be multiple or none); remaining columns are various
accounts & subtotals (bank, stocks, margin, etc). Separate data set is
entered on page one: two rows of data only, C1'=date (both=today()),
C2'=hi
valu in R1, lo (negative) value in R2. The idea is to generate a
perpetually
advancing "today" rule across the chart. Dates appear in chart as
abbreviations for month JFMAMJJASOND though display in data page as
metric
date yy.mm.dd. Multiple subtotals display on chart as scatter chart
(lined)
of daily data. The whole thing works like a charm in XL2003, and even
works
in XL2007 (after essential hotfix) except for the vertical "today"
rule.
(Why such a Rule at all? Because I plot pro-forma advance data to year
end.)
Driving me nuts, but there must be a way. I'm missing the clunky
nuts-&-bolts approach of prior XL versions - perhaps not Mac-like in
aesthetics, but incredibly powerful.
:
Are the X values in the main chart dates? Are they plotted as dates
(weekends have a place on the axis although no trades occur then) or
as
categories? If they are plotted as categories, the X1=X2=TODAY() will
be
way
off scale.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
In XL2003 annual multiple-account financial charts with daily data,
I
used
a
second data set X1=X2=today() & Y1=[a high number], Y2=[a low
number]
to
create a vertical "today" rule on the page for clarity. Won't
display
in
XL2007 notwithstanding charting hotfix applied. Any comments,
workarounds?
I can't even see how to create it from scratch in XL2007, the thing
seems
to
preclude multiple X-value data sets.