I've scoured the internet for an answer to this and still no luck.
I want my pivot chart to display the overall average labor time (y-axis) for
every order (x-axis) that ALL customers have placed. If I tell Excel to plot
average labor, it averages the orders for each customer and ...

I am trying to make a comparison line graph. There are 3 options of
line graphs in the Chart Wizard. They are line w/markers, stacked line,
and 100% stacked line (respectively). I would like to use the "line
w/markers" option, but after completing all the steps in the wizard my

How to add targets on a PivotChart

I have 3 data series.  I would like to make Series 1 a clustered column, and
Series 2 & 3 a stacked column.  Is that possible?  If so, could someone
kindly tell me how to do it?  Thanks in advanced for any help.

Is there any way to referencing to data source range with formula?
For example I would like to insert this formula to the data surce page (if
it would be possible) :
=Address(32;12;1;True;"DEF_Montly")&":"&address(32;DEF_Monthly!$A$1;1;True)

how do I do a Dispersion chart in Excel

I plotted months vs numbers in excel and got a trend line with an equation.
When I try to put my xaxis (months) in the trend equation I am getting
strange results. -ve results why so? If I replace months with numbers then I
get the right answere.

I am using a line graph to chart 2 years worth of monthly data (each year a
separate line).  I also want to show the YTD totals for both years as a bar
graph (i.e. if the current month is August, I want to show the Jan - Aug
Year 1 total as one bar graph and the Jan - Aug Year 2 ...

How can I set the X and Y axis minimum and maximum values by reference to
variable numbers in cells.

I have so many data series on a chart with (widely different values), that in
order for the whole legend to fit, it takes up half of the entire chart and
the chart is nearly impossible to read.
I would like to put the legend on a separate page but have been unable to

Hi, I am curious to see if anybody could create a visual relationship between
a point on the chart and the data cell. Let's say if we have 1000 points on
the chart, when I point to one of them--it will show the values--but I still
have no idea where the point actually comes from. ...