Is it possible to search a cell for a key word or words contained in text made of multiple words enabling the user to than create a pivot table using the...

I believe it will be useful to add an option to Excel that when adding a tendline to a graph, Excel could ask in which cells it will store the coefficients and...

Hi, I have five and a half years of data that I am trying to plot using an area graph. My problem is that after the half year the data drops to zero, which...

I am trying to create a graph like this: http://www.ergonomics4schools.com/images/lzone/anthrograph.gif Any help would be greately...

I have to loop through a significant number of charts applying numerous changes in formats. The speed of operation is fast when I am operating my computer...

I need to create a chart (line chart) data series, but based on two different columns of data... Is this possible ?

Is it possible to have a pivotchart with a primary & secondary axes in Excel 2002? If so, how do you setup the secondary axes? Thanks

For example, I want to change the colour of the chart, the background and the legend on several charts - all to one new colour. Is there a quick way to copy a...

How do I show the subtotals and grand totals calculated by the pivot table in a pivot chart?

Hi, I have never been able to get the full title show up in excel on the y axes. It always truncated is when I align it at 90 degrees. For example, I am trying...

I would like to create a chart similar to a bar chart, except that instead of a bar, I want to use a symbol. For example, for 5,000 units I would like to see...

I have several spreadsheets that contain several workbooks each. Each workbook has multiple charts (xy scatter) plotting test results (y-axis) vs date tested...

Can somebody suggest any third party Charting Add-ons/Plug-ins/Controls that expand the charting capabilities of MS Excel? Such that may be code-controlled in...

I have lots of scatter charts plotting data in columns. At the top of each column is a cell containing the label I want to appear on the axis. I would like...

I would like to create a Defined Name range to use as a the value for a series in a chart. Example: Cell B2 equals January Sales; Cell C2 equals February...

Is it possible to set up the Legend so that it only shows when it is in prited format?

I need to create a bridge chart. The floating bar char might work but it will not allow a bar to cross over 0 between negative and positive. Any help will be...

I am trying to smooth the angles in pie chart which prints okay from an excel but not when I copy and paste it on a microsoft word document Instructions said...

I have created a graph and I know how to add a data table to the bottom that has the data in the graph. However, I wish to put different data in that table. Is...

How come...when you change the source data...in other words...expand the data series to incorporate new data within a chart.. save changes then, exit the...