I am trying to create a chart for data that is on two
different tabs within the workbook.  Has anyone had any
success with this or is it a limitataion of Excel?
Thanks in advance!

how can I use the offset function to select the starting
row and ending row of a range I wish to chart. I have 100
rows but I wish to select any 10 consecutive rows to
chart, by, say, typing 7 into cell A1, so that the chart

Does anyone have any information on how to create an X, Y, Z scattergram chart in excel?

Is there a way to create a drawing from an Excel chart?
This is for an economics class; we are allowed to just use
paper and pencil but I want to learn more about my software
anyway and this is a good excuse.  I need to construct

Hi –
I have multiple groupings of three charts.
I need to add a fourth to each group – np.
I can resize the existing three to fit four across a page but need to increase the Plot Area to fill out the resized charts.  This is all fine and good but once I lock down the adjusted plot ...

The default Plot Area color in Excel is gray.  Is there a way to change this
to another color?

I have created numerous tables where the row fill colors  
represent a country's name i.e. US is a red fill, Mexico
is green fill etc.  When I make a chart either bar or pie,
I want to have the bar representing the US be red, Mexico

I am trying to create a plot of
y1 vs x
y2 vs x
y3 vs x

I dont see the floating datasheet with charts in Excel
2000.
I have user who has created a chart and wants to
hide/remove data and add more data to the chart without

Is there a way to list all files in a directory into a
database in excel i.e. with a row for each file and
columns of the listed file properties from explorer.

I really don't want to have to learn VBA - I know enough to make out what my Excel macros are talking about, but I just do not have enough time to learn all the ins and outs of charts and graphs programming.
However, my boss is not an accountant.  He can read a financial statement ...

I have a long column (about 1000 cells) in my excel spreadsheet which
consists of Y (yes) and N (values).  When I try to create a pie chart
telling me what percentage of N values are and how many values of Y
are I get a wrong chart, I do not know how to do this since I do not

I'm trying to make a chart selecting the whole column as
data to plot on the chart. But it doesn't work .. I have
many rows with data (about 250) and it's going to be
more .. How do I make this chart only once, without

I am trying to create a 'Line - Column on 2 axes' chart with the market share of 5 companies on one Y axis and the total market volume on the other (X axis is months). I want the market shares to be lines, and the market volume to be columns. I can set which axis each series ...

I want to list the names of 5 birds, the date I took its
weight, and the weight of the bird.  How do I set up the
spreadsheet so that I can make one graph that has five
lines, one for each bird, and plots their weight