I'm new to this forum, but I am so happy I found it. I'm having a
charting problem in Excel that has been driving me nuts! I'm creating a
chart based on weekly data. So I have a chart that is broken down by
week as follows 09/07/03, 09/14/03, 09/21/03, 09/28/03.  But this week

I want to place a transparent box behind the bars of a bar
chart to denote a highlighted section of a timespan. I can
get the transparent autoshape in the chart but I can't get
it to move behind the bars. Can anybody help?

I set up a chart that graphs changes in quantity over time.
It's source data comes from multiple different places in my
spreadsheet, so, to make it easy to graph, I use formulas to set it
out nicely.. namely, two rows, the top with date and the bottom with

How do I define a chart to be a two axis stackbar-line
chart.  I can find in "Custom types" a bar-line chart, but
the stackbar on one axis with a line chart on a second
axis eludes me.  Is there a way to custom type this?

I want to set calculated values on a sencondary axis in a simple
linediagram.
On the left side of the diagram the axis values are
100

I need to draw the graph of tan x, which involves the use of infinity.
Can anyone tell me either how to display the infinity sign or
alternatively how to represent tan x in graph form in excel.
Many thanks

I would like to know if you can apply some conditional
formatting in a graph data label. An example is if a
variable X is below a determined value Z then in the
graph the data label for variable X is in red, but if X

I need to create a chart in Excel in which each point has
an X and Y value, reading the info from a table of data.
When using the "scatter" chart type, it doesn't do that,
instead it draws two series' of points, one series for the

I have a table with 3 columns.  2 of the columns include
the X and Y values for the plot (results should be one
line plotted on the graph.)  I want the 3rd column values
to act as corresponding labels to the plots.  Example:

All I want to do is put text in the Y axis area.

I'm new to creating charts.  I want to create a pie chart
with both percent and value data labels.

is it possible to reformat the y axis on graphs, so
instead of seeing 1 2 3 etc i can see A B C up the y axis

I have a series that I chart as a column, "Precipitation"
and three series that I chart as XY Scatter, "Plant Cover
1"...
I created the chart as a column chart and when I change

H1!,
I have an Excel spreadsheet which contains X-coordinates,
Y-Cordinates, Well name and Cumulative Oil/Gas/Water
production. I have created bubble map using X,Y and Z(Cum

Is there a way to create a bar chart and have the colors
be selected from data adjacent to the plotted data?  Or
is there a macro that can select cells which can change
the color of the fill/texture?