Few weeks ago I have seen a presentation where by using custom format it was
possible to format the Y axis so that it was displaying the % only next to
100 and all the rest of the axis was displaying numbers without %. It was like
100%

I need to format my charts so the color of the data points change depending
on the value amount. My tabels are already set up and cannot be change or
have anything new added due to the amount and delicacy of data. Is there a
macro I can use. Perhaps a formula I can put somewhere?

I've got a spreadsheet with about 60 columns and I need to hide the first
thirty or so.  Each month, I'll need to hide one or two more from the left
while one or two more are created off to the right.  It's an ongoing range of
dates, if that makes more sense.

I would like to show modes in the form of a pie chart but am not sure how.
For example the number 73 comes up 3 times in a column on my spreadsheet, how
can I show that compared to the number 50 which come up 2 times in the sheet?
Thanks for the help

I need to format the CHART AREA COLOR based on a condition. If the data is
higher than a certain amount I need the CHART AREA to be RED.
I do not know VBA too well so please give me as much detail as possable.
Justin

When I added an equation to my logarithmic scale plot, it gave the equation y
= 53.243e-1.6094x.  Is the slope of the line embedded in this equation?

Column & Bar Charts juxtaposed to each otherin that 'X' axis in one chart
becomes'Y' axis in the other. Can't we do same with the Line Chart.

Is it possible to have multiple Y axis on a chart?  I see that you can
have a primary and a secondary axis, however what if you need to have
many - say 5 or 6?  (Perhaps the measurement units are a different
format).

I would like to scale several pis charts in comparison to one of the charts.
ie say one pie chart represents 500 total items then the second chart which
has 250 item would be half the size of the first chart and so on. I'm using
excel 2003

I have a Pie Chart, with a legend.
Is there a easy way, to erase the legend keys in the legend?
If I change the color, the color of the linked slice changes too!
I'm glad for any suggestion.

I want to show all data bars that are less than zero to be Red in color and
all positive data bars be Green in color.

Folks, just a nice one I came across I like to to share with you.  An
interesting feature in data analysis can be to use in-cell graphs.  See
http://www.juiceanalytics.com/weblog/?p=236
Have fun.

I have a worksheet that imports data from a source.  It brings in data for
the past 24-hours.  I want to see the last 24 hours, a 4-hour window, and a
1-hr window (not all at the same time).
I have 3 buttons that change a worksheet defined variable (Defined Name) to

Dear
I would like to draw a chart in Excel like speed car counter.
Please give me your advice to reach this point.
Thanks in advance.

Want to plot equations and functions graphs in excel.