I'm sure this is naive.  In Excel 2003 I'm trying to construct a line graph
in which there is is more than one set of matching x and y values.  For
example, the data looks like this:
x1         y1      x2         y2

I am trying to graph daily data for a month in Excel 2007 that groups like
days (Saturdays, Sundays, etc) in the same series, while still showing
individual values and dates.  Any ideas on how to accomplish this?

Can you highlight/fill individual cells, rows, or columns of a data table
within a chart?

Can you highlight an individual column in a Bar Chart?

Hi, lets say i have a cell A1 that shows the text B1:B5, and i have a cell A2
that shows the text C1:C5. Then i want to have a chart that references cells
A1 and A2, and hence knows that i want it to chart the data in arrage B1 to
C5 (an x-y scatter plot). the point being the ...

Hello;
I posted this back in July in the wrong forum ("General Questions"); since I
didn't get a response, and the problem persists, I'll post it in this forum.
When our lab computers were running XP and Office 2003, I could easily set

If i have some data in percentage month by month. In some of the
months i dont have any data.
In this condition if I draw a line graph the line goes down to 0% and
again it comes up which create a wrong picture in the mind.

I am trying to plot weekly sales in a given year.
Eventually in a year, there will be 52 weeks of sales labeled date,this yr
sales,last yr. sales.
I am using a line graph.

I continue to find a problem in excel 2007 that was not present in 2003. I
will input 2or more columns and rows of  data to create a chart, then create
the chart; but IF MORE THAN ONE  data path is selected to be charted, the
other data paths are charted incorrectly. They do not ...

I have a pivot chart based on A1 thru D10 in and Excel 2003 workbook.  I
would like to expand it to A1 thru F20, but I don't see how that gets done.
How do you respecify the data range for the pivot table?

Have the specific knowledge base instructions.
Instructions state to in the chart, select the data series, then via Format
menu, Axis tab, click the secondary axis.
I can't seem to select the individual data series.  It tends to select all

I have a spreadsheet with about 10 columns of data. The number of rows can
vary but its ussually less than 20. I've got a set of 'index' fields that
define which data is in which column and what range of rows I want to act
on.

I need to create a line graph with the following information:
The Johnson family is planning a weeklong vacation in California and needs
to rent a car. They don’t know exactly how far they will drive, but they
estimate between 400 and 800 miles. Here are their options:

I have been told to make a chart template in Excel 2003 with a traffic light
background, i.e.Green ,Yellow, red. I know how to do a spreadsheet. How do
make a line chart background

I have a line chart.  I am happy with my X axis categories, which say
something like "Term 1", "Term 2", "Term 3" etc
However my Y axis reflects the actual values (eg Points scored) that I wish
to chart, whereas I want it to contain descriptive terms such as "Grade C",