I have a data set plotted in Excel.
Is there any way to show automatically the minimum, maximum and median value
of this data set on the chart? (In a form of label or anything similar)
Minimum and maximum values are already part of data set.

hi there i'm having trouble trying to overlay 2 graphs together, the
are shown below.
'cost graph
(http://img398.imageshack.us/img398/4893/costgraph7bj.jpg)

I have a worksheet with about 150 rows and 50 columns.  I would like t
create a bar chart for each rows worth of data on a seperate worksheet
using the column headers as the labels on the x axis and the cel
contents as the y axis (with the first cell in each row as the char

I have created a line chart with two Y axises based off of a pivot table.  
After the chart is created I customize the text, colors and line widths the
way I want it  as well as remove the pivot fields and then save it as the
default chart style.  However, whenever the pivot table ...

I would like to incorporate and display the percentage of the dat
series in the Data Label of Column chart. Can anyone help me in thi
regard, by giving a solution, w/o writing a macro?
Thanks in advance

I have created a dynamic bar chart, roughly based on Stephen Bullen's
funchrt4. The number of categories can range from 2 to about 50 and ideally I
would like the category axis names font to be Arial 10 at least.
When the number of categories gets towards 50, the category axis ...

Hi, I hope someone can help me!
I am creating a chart showing the revenue, profit, and profit margin for
each of our clients.
I would like to have the revenue and profit appearing as stacked columns

I am trying to build a chart that regresses two sets of gross revenue
numbers, based on anticipated price sensitivity.
In other words:
Right now, I move 100 pieces a month. Sales price is $75 each. So, gross rev

All,
I realize this is perhaps not the correct forum for this question, but
it has proven difficult to find exactly the right forum. I have in the
past done some charting using VB from both Excel and Access. There are

I need to know how to hide data labels that show a zero value on
histograms.
On *line chart*, I've put "=NA()" instead of the zero returned by the
formula, and it functions, but using the same technique *with

I need help with creating a formula.  I want to count the total number
of individuals who meet a certain criteria in one column and a certain
criteria in another column.  For example: I want to find out the total
number of people who live in Germany and went on a specific trip.  For

Hi, I thought I was well versed with Excel and charting, but...
How can I create a chart with several lines, where I indicate the X and
Y coordinates?
For example, a chart with X = 100, Y = 100, and another line where X =

How can I have a bar chart (cash flow) change color based on the value of a
point -- either positive or negative?

I have data for several charts, all of them need to on the same grid, so that
the vertical axis is the same size, scale and has the same set of numbers.
The data changes and the information on the horizontal axis changes.
How does this get set up?

Hello News Site I was wondering If I could create a Line Chart and define
into it two values as Maximun and Minumun beside of my own data table values.
I meant max and min values will values to compare with my data table values.
So Can I do that?  and If I do, may you let me ...