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 ...

In the new Vista Excel can you tell me where I can index one data series to
another?

I have a problam creating an XY chart in excel 2007
for each point (x,y) is in a certain group and i want to create a
chart that color each point according to it's group.
I tried to put each group in a diffrent series, but I only managed to

In order to be sure of the filename & date that a chart was produced I
have to datestamp it with a text field containing:
TEXT(NOW(),"YYYY-MMM-
DD")&MID(CELL("filename",A1),SEARCH("[",CELL("filename",A1))

I have a problem with Excel 2007 loading a chart in a spreadsheet that was
created in Excel 2003.  It takes forever to display the chart.  A very
helpful Microsoft rep told me this is a known issue with Excel when one or
more axis settings are Fixed rather than Auto.  Changing ...

I would like to automatically create a graph of some data after loading a CSV
file. Perhaps by writing a function in the text of a cell? Or perhaps by
including some VB script?
Is this at all possible? Is there another file format that could be used?

I am trying to create charts with multiple groups of stacked bars.  For
instance, for one value on the y-axis (doing horizontal stacked bars), having
more than one stacked bar per that one y-value.  Right now I can only get
Excel to do one stacked bar per y-axis value.  

I'm trying to create a clustered column graph with mixed data in the 2nd
column and I cannot find a way to do it.  Any suggestions?

Hi there I need to create a 3 variable, and 3d (rotatable optional)
scattergram using a logartihmic scale on the x axis.
x axis range: 0.1 - 7,000,000
y axis range: 0 - 1

I have the mean values on my chart in the form of a line graph, but would
like the range (min and max) to be displayed as a line above and below each
mean. How do you do this?

I have created a scatter chart where the numbers on the Y axis are small
numbers but start after 1 i.e 1.24, 1.35, 1.4.  Trouble is the wizard
automatically starts the scale from 0 which means the chart is bunched at the
top as here is no data between 0 and 1.  How can I get the ...

Hello, I am trying to label a data point in a scatter plot but it
keeps returning the x value.  I'd like to have the store # instead.
Basically I have Store #, Acceptance % and $ Value Eligible.  Right
now I have Acceptance % as my x-value and $ Value Eligible as my y-

I have a worksheet which has a column of numbers which must be charted using
a line chart. Currently the column has 48 rows, but additional rows will be
added as more data becomes available.
Is there any way (maybe using VBA) go get the chart to update the data

I have 200 data labels that I am trying to put onto a bubble chart. Each
point has 3 values. I can easily graph each point by selecting the cells in
the columns, however I can't figure out how to name each one without having
to go and manually enter every single data point (200 ...

I have 5 sheets and would like to build a stacked bar graph using data from
each.  Say I have 4 values in A1, A2, A3 & A4 on each of these sheets.  Each
stacked bar is to respresent the 4 values from a single sheet.  Is there any
way to do this with out having to build a table on ...