Is there a way to graph data which utilizes the "fixed" function for decimal
places? When I try this it will not graph, as the data has become text or
something - even though I've selected number in the cell formats.

I would like to create the template which will present user with several data
entry forms, calculate result and then should presend result as a serie of
charts with next button to show next chart. Is it possible to display just
the chart windows for each chart or they have to be ...

I am trying to make a chart that tracks the average of a quality assessment
monthly.  Basically I have 12 worksheets, one for each month.  The average
grade (1-5) for each month is calculated in the same cell on each sheet.  How
do I get a line chart to display this value from ...

Is there a way to display both primary and secondary axis on the same side of
a (linear) chart

I use pivot charts frequently, and change the data displayed frequently.  I
would like to "lock" my stacked bar chart colors so that my largest data
segment in the legend always displays blue in my stacked bars, my second
largest data segment always displays red, etc.

I have a simple data set  of:
Column A:  X axis
Column B:  Y axis
Column C:  Bubble width

I'd like to make a simple XY graph. I want a 5 x 5 grid with two points
plotted.
My problem is, I want the points to fall between the grid lines, not on them.
In other words, for a point of X=1, Y=1; I want the dot to be in the middle

Can I make a pivot table more permanent in size?  Instead of it constantly
changing when the data changes, can the columns and rows be fixed?  I'm
pulling data for a summary page from the pivot table for head count purposes
and when this data changes, the fields in the pivot ...

Is there a way to convert an excel graph into into a JPEG file

I'm trying to overlay 2 different chart types (xy scatter & bubble
over each other, both charts using the same data range.
how can I do this, or make 1 of the graphs transparent
--

Hi Andy,
I have seen the addin. Somehow it doesn't work on my machine (maybe it
something to do with my settings for the graph), but the main reason i
that the code is not available and I don't want to install addins.

I've never used excel before. Are the courses list in the order in which I
should learn? If not which one should I start with?

How do i get my data labels to appear in the center of
each column on my chart? Thanks.

I made a chart of a pivottable. This works. But when I have a selection in
page field (f.i. a country), that does not contain all the rows (f.i. only
three months out of 12), I get a graph with only that rows (3) selected. So
far no problems. But when I change the selection in ...