In 2007:
1. clicking on a data point on an x-y graph, when the row-column
designation is reversed, makes it impossible to pick a particular data
point.  Clicking on one will pick a nearby one!

I have a simple Bar Chart, and can't seem to figure out if there is a
way to select, say 5 of the bars and apply color formatting to those 5
all at once.  I can select all, and then on the next mouse click, I
can select an individual bar, but in holding down the CTRL, SHIFT, and

Every day I update a spreadsheet for our daily sales figures.  Associated to
that spreadsheet are several different charts including some bar charts. Is
there a way to auto-sort bars within a bar chart from the lowest number to
the highest or vice-versa without having to manually ...

I need a barchart that shows, for each time period, two adjacent bars, each
of which is composed of two or more elements (which will stack vertically).  
I can do those things separately but there doesn't seem to be a chart type
(either standard or custom) which does this.  Can I ...

I have groups of data points in categories.  I can easily calculate the
average in each category and show these as a bar chart, but is it possible to
show the individual data pioints in each category as well?
Thanks,

I'm printing charts in Excel. Some of them are adding blank pages at the end
of the charts. How do I get rid of these?

I would like to capy an excel chart to a word document and not have gridlines
show up in the word doc.  The chart has a .tif header attached and the antire
thing will need to be resized bacause I am going from a landscape format in
excel to a portrait format in word.  Both excel ...

I wish to create a horz. stacked bar chart for PC refresh cycles.  (unit in
years)
sample data:
      installed    refresh   refresh

I have a chart.  It may be based on one of several different queries.  I
am not sure which.  I also can not find out which.  If I right click and
choose "Object Dependencies", it says there are none.  If I open it in
design view, and choose properties, the value for "Record ...

I have a chart with two straight lines that move daily.  I would like to
setup some kind of conditional formating so that 2 of the 4 quadrants that
are created from the intersecting lines are colored different colors from the
rest of the chart.  

Currently using 2 workbooks to produce 1 chart - the source data in workbook
1 and the chart in workbook 2. We also are using the "show data table" option
to most easily view all values in the chart.  We would like this data to keep
it's currency format to best reflect the values ...

For a project I'm working on I have an area graph that has two series (actual
data and projected data). As the x-axis has weekly data i'd like the point of
the "actual data" to flow right into the "forecasted data". This works but
for some bizarre reason the vertical line that ...

Is is possible to supress Data Labels (Values) via conditional formatting?  
I tried an IF Statement that returned a blank ("" or " ") if the condition is
true.  However, the value of zero still appears unless I completely delete
the cell's contents.........

For some reason I am unable to paste text into a chart text box,
(with excel 2007).
Is there a trick to this?
Gary K.

I want to sum data in cells when the data meets the criteria given in
seperate cells. SUMIF cannot handle this; can someone advise another approach
using formula?
e.g. project type is defined in Col A, Yearly data in Col B, C, E