I plotted months vs numbers in excel and got a trend line with an equation. When I try to put my xaxis (months) in the trend equation I am getting strange...

I am using a line graph to chart 2 years worth of monthly data (each year a separate line). I also want to show the YTD totals for both years as a bar graph...

How can I set the X and Y axis minimum and maximum values by reference to variable numbers in cells. -- Excel R&D

I have so many data series on a chart with (widely different values), that in order for the whole legend to fit, it takes up half of the entire chart and the...

Hi, I am curious to see if anybody could create a visual relationship between a point on the chart and the data cell. Let's say if we have 1000 points on the...

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...

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...

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...

Hi, after full installation of MS Office 2003, I tried to insert a chart into a worksheet. But, when I go to standard chart types, I can see ONLY 1 chart...

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 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...

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?...

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...

In using a pivot table and pivot chart, how can I only show one row value, but still be able to show the percentage of the whole set of rows? Thanks for any...

Hi everybody 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...

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...