I have a chart that is using columns for category "A" on the primary x-axis
(a $ amount).  This category is broken down first by person, then by month.  
So essentially from left to right the columns will be person "1" and month
"1", person "1" and month "2", person "1" and month ...

I am using three points to create a Venn Diagram with the Excel Bubble Chart.
At the moment, the bubbles have no FILL; if I use a different colour FILL in
each circle, how can I use the TRANSPARANCY so that I might be able to see
the common, and triple overlapping area?

I have a 'dynamic' chart where the source data comes from two drop-down
boxes -- the results of these drop-downs cause different results from a
VLookUp formula.  Currently, when a user changes the drop-down boxes,
the graph changes automatically with each box.  So, if the user ...

If I have a column of non-numeric data (for example 500 different fields,
each field stating the color of a car ie green, green,green, red,red, silver
etc) how do I draw a graph showing the frequency of each colour type? For
example green 200, red 100, white 100, silver 100 ...

I clicked on 'clear' on the y axis (value axis).  According to Chart Options
it is still there however it's not, I cannot see it anywhere or have it
returned.  Help please.  I need to rescale the graph!

Trying to do the ol MouseUp thing.  XY in screen coordinates, blah
blah.  I can get the xy relative to the window.  I went thru the API
calls, finding windows, some enumerations (because the class names
weren't quite like in the posts) etc. Got it.  Woohoo.

I'm trying to use the BETA to create a histogram.  It always graphs the bin
values as well as the frequencies.  How can I get it to stop that.

In my job I very often create charts from excel data. Then transfer that to a
graphics program to add more and better graphic styling. Then embed this into
Quark documents for high quality print output.
I am looking for a way to enhance the styles, set print safe colors, and

I recorded a macro to create charts using the Wizard, but ran into a
problem.  My X-axis is in Col. A.  The label is in A1, and the data starts
in A5 (time).  I modified the macro to use the last data row, and I also
modified it to use other ranges for data, keeping Col A as my ...

How do I make a chart with stacked data and a single data set next to
ieach other?
The second chart on this website is what I am trying to do:
http://people.stfx.ca/bliengme/ExcelTips/Columns.htm

I'm working on a macro to get a chart from a dynamic range of cells
(selected according to the date introduced for the user in the worksheet).
The problem is that I store the selected range of values in variant vectors
(1D arrays), as decimal types. In the below code these arrays ...

howdy
ive got a chart which gives production values by year for different
countries. the problem is one country starts production in the middle
of the data range and so excel draws the line from zero at the year

I have a spreadsheet with dates in column A and times in column B (when data
was gathered).  I have a chart using the x-axis for column A (date).  How can
I also get the chart to display the time?  Basically, right now the x-axis is
in the format 09/24/06 but I would like for it ...

I have an Excel program, created with Excel 2002.  All is fine.
Transferred to Office 2007.
Now, in the charts (x-y scatter charts with two data sets each) the data set
markers do not show up in the legend.

I have a line chart with two set of data (1995 and 1996). The months are
along the bottom.  I have added horizontal lines for the average value for
each year.
What I'd like to do, however, is divide the background into different colors