I'm trying to get the legend to stay anchored above the chart by setting the alignment to 'top', however whenever reopening the file, the legend falls to being...

I need to graph the months on y-axis and region names on x-axis and then plot a numeric value in the plot area. For some reason I cannot make it work. Any...

Task name Start Date Complete Remaining Start date % complete Locations 27/11/2006 8.8 2.2 8/12/2006 80 In complete cell this formula is used...

Hi, Im using Excel 2003 and lets say I have sales data on 30 stores in which specific promotions were run (Test Stores). Since its a consolidate monthly data...

I'm trying to use the forecasting model but I don't know what number or operation I'm supposed to use in place of E. In my case, x = 37. I'm sure it's...

A client wants the x-axis tick mark label (bar chart) to be positioned under the tick mark instead of between tick marks. We've managed to do this before but...

In a bar chart, how do you put a dollar sign on only the top value axis in Excel? What is the formula?

Is it possible to change the color on part of a line? The whole line is Red, but between point C and D we would like to have the line green and then go back...

I have a bar Chart running showing calendar days available to a 'point' and I have to increment this manually so that it shows from the current date. Does...

Is it possible to change the individual marker style for a particular month in a line graph in the same way we can do conditional formatting for a cell? For...

I want to create a chart with 2 100% stacked columns to compare % of 2 different years.

Is it possible to have one pie chart of a large radius and then a pie chart with smaller radius placed on top of the larger so the centers of the to pie charts...

I have the following data Name Value Alias A 102 aaa B 323 bbb C 234 ccc D 121 ddd E 121 eee I created a simple bar chart based on Name and value.

I currently have a static chart that shows a range of six months at a time. Every so often I have to go in and change the source data to not only accomodate...

Hi, I was referred to an article by Jon Peltier for how to trap chart events and it was very helpful with trapping mouse clicks on all areas of a chart. ...

I have a number of PivotCharts with data tables, each linked to a PivotTable. The fields in each PivotTable are broadly similar and in exactly the same order...

Hi, I accessed the Help Menu for this Q. and it says that I have to go to -Format-Select Chart Area-Options Tab. Here, I'd have to select the type of lines...

I am using Excel 2003 I am working on 2 line charts created by someone else. They had a problem with the charting and asked me to help fix it. The easiest...