I have embedded links in some files, but there are no
names in the worksheet or formulas which are linked to
other workbooks. Does anyone have a method of deleting
these 'ghost' links.

I have a set of data that I need to put into a simple line graph.  
need the chart to recognize and add new data points into its data se
as I enter the new values.
I have tried to extend the data range by another 40-50 empty cells s

I've attatched an image with the chart's X-axis labels i would like t
emulate.
My chart is the second chart in the image.
Thanks for you help!

I have a list of several hundred orders and I want to
graph where they ar coming from. So I want to count each
state and pir graph that. Is there an easier way than
going through the "Data, Subtotals, Count" then

Is there a way to get more than one line to appear on the
line chart when they both have the same values at certain
points?  I have a chart where three lines occupy the same
values at 2 points on the X-axis and I want all three

Good morning to everyone.
Does anyone know if Conditional Formating have an issue
in the charts?
i have make text boxes which bring values from another

I have a few questions relating to bubble charts - if anyone can help I would be very grateful
1) when I select a range of data and make a bubble chart out of it (using either the wizard or pressing f11) excel seems to have a fit - when I look at source data>series the ranges are ...

How do you chart data from three sheets within the smae
work book on the same series on the same chart? it seems
to want to create a new series unstead of charting year 1-
3on the one series.

Anyone know why when I build a user defined pivot tbl
chart all the data in the second chart matches the data
in the first even though I selected different data?
Thanks in advance for the help.

Sounds simple, but I can't seem to figure it out.  I want
to convert collumnar data into rows to use in a 3D
graphing application.  
For example, I want to covert data like this:

Can anyone tell me how to make a stacked column chart using rating data (eg, excellent=5, Very good = 4, etc)?  I'm trying to enter data from a survey to chart and I am not sure how to enter the data from rating questions so that I can plot a stacked chart (rather than just ...

I need to present a bar chart with segments that represent periods o
time a policy was in force.  The segments can have thre
conditions/colors as follows:  Prohibited/Red
Permitted_under_Restrictions/Amber, Permitted/Green.  The trick is tha

I've series of data (functions not original data) staedy
for 12 months this year and i would not like change it!
Actually we've July and in remain months on linear chart
fall to zero. I want only linear chart (i know in another

I'd like to be able to build a chart using multiple XY datasets -- say
from two different experiments.  If I plot the two columns of dataset
as XY, then Add Data and try to plot the two columns of dataset B,
get an XY plot (A), overlaid by two line plots, one for each column o

Wonder if anyone can help here.
I use the following formula to create a series for a graph
trend.
IF(ISERROR(A1/B1), "",(A1/B1))