OK here's the problem.
I have a multipage Excel spreadsheet with a consolidation
chart page at the end.  The chart page grabs data from
individual store pages and displays sales data using a

I'm trying to make a chart from a pivot table, but only
from certain colunms within that table. Therefore I made a
second table next to it that just equals the pivottable.
From that second table, I made the charts I wanted. If I

Is there a way to name a chart so the name will stay with the chart
regardless if the location is changed?
I can name a chart while its location is on a regular worksheet;
however, if I move its location to a new sheet, the name goes away.

Would like to have a full-sized chart worksheet that has a pull-down
menu on it so I can select a different product to show while viewing
the chart.
I can do this fairly simply in a regular worksheet where the chart,

I have a s/s tracking late shipments.  Each column represents a different reason for being late with the total # of shipments that fall into that category under it.  Each day of the week is tracked on the following rows.  I have a case of one reason falling under another, i.e., ...

I am currently trying to plot the date versus sunset times. (ie, 1/1 on the
x-axis would correlate to a sunset time of 5:26 on the y-axis). Excel
doesn't recognized this. Anyone have a suggestion on how I can plot this?
Thanks,

I am an average Excel user, but I can't seem to find out
how to keep values from printing on top of gridlines.  It
is very frustrating!  I have searched knowledge bases and
no luck.  Any help out there?  This really only applies

I have to find the X-intercept on y-axis and y-intercept on the x-axi
and display the intersection on the XY scatter chat as well as show th
intercepts using dotted line.
Can anyone help me with this.

want to find the cursor position within a chart in chart coordinate system in my Chart_MouseMove procedure. In oder to do the coordinate system transformation, I need a way to get the ".Left Property" of the Chart, ChartArea, or Axes(xlCategory) object relative to the active ...

I ran into this problem I do not seem to be able to solve.
I work on an app that exports data to Excel. All data has dates (or hours
within a date) as the X-axis. Some of the Y-axis data is numerical (no
problem at all), some is completely "time" (Like: hours worked at a certain

Hello all. Here's the data:
Row..............Column A (x axis)........Column B (y axis)
1.........................1/1/04.........................$50
2

I have 14 charts spread across three (printing) pages. They all share the
same format;
Green line (no symbols) = Target
Blue columns = Monthly Actual

Mid doesn't allow stringing each of the 2 char fields
together as an answer.
cell A1 has 03/17/04 and would like A2 to have 031704.
Macro coding please. Thank you ahead of time.

I can't quite see it, but it's got to be with "TEXT".
I have this..
   With ActiveChart
       .HasTitle = True

Is it possible to produce venn diagrams in Excel (or any
other program)?  I can draw circles and text boxes etc,
but it would be nice to do it automatically.
Thanks