How do I graph quarterly data which appears in Excel with gaps between the
mon this, like the first, and second columns below (the third column is
monthly):
Do I have to clean the data first, or is there a trick?

I created several user-defined chart settings in an Excel spreadsheet.  
However, when I emailed this file to my coworkers, these settings were not
attached when my coworkers opened the file on their respective computers.  It
appears that user defined settings are only available ...

I want to add data points to the scatter plot that are not part of the data
ie. add points to find their concentration on a standard curve.

I'm looking for an excel add-in that works like miner3d software (see
http://miner3d.com/products/)
I'd appreciate any suggestion...tia

I cannot find any directions for creating stacked pie charts - as in
displaying a series of data content for each pie slice.

I am trying to chart data for each day of the week except Sunday.
I am using a stacked bar graph with volume on the y axis and the date
along the bottom.
My week runs Friday to Thursday.

I am trying to use the DataLabel.Position contruct to change the position of
a data label based on which series of chart data that it represents.  Using a
statement like DataLabel.Position = xlDataLabelAbove seems to work fine in a
macro.  When I try to use the same code within a ...

In the worksheets, I can easliy turn off display of zero values. In the
charts, I cannot find i similar option.
When formulas return a 0, N/A or empty cell (""), the chart seems to handle
it as a 0. I do not want to display those data points at all. How do I do it?

So that the text doesn't wrap in appropriately?

I want to colour the plain at the zero level on the y-axis.
Is this possible?
Greets
Xaver

I have date and time in my first column for my x axis, but I can't get both
date and time to display in the chart.  
My data spans two weeks and now displays as I want it, but the data is
useless without showing the relevant date/time for the data points (across

I am able to creat a line column graph on 2 axes.  That shows $ as columns
and % as a line.
However I wnat the colunms to be stacked colums.  Can this be done?

I am trying to make a single line graph a x axis (vertcal side) showing
breathing rates per minute, and the Y axis )horizontal axis) gin-ving time in
minutes.

Yesterday my chart wizard went crazy
A simple chart, I've done them thousands of times
Now when I select 2 series and try to plot a 2 line chart the first
series plots fine and the second plots as the sum of the two series.

I've a weekly chart that shows the weekly candlestick chart for the fund
prices and a 39-week moving average line.
Now, I have so much data that I only want to plot around 2 years' data on
the chart.  If I select this range only and let Excel create the moving