Hi, I have inherited a workbook from my boss. It contains some Pivot tables and Pivot charts. Strangely one of the pivot charts has no field buttons in it....

I have four data series, it shows 2 as bars and 2 as lines. I want to show just one series as bars and 3 as lines. How do I change data series 2 from bars to...

I'm using Peltier's http://peltiertech.com/Excel/Charts/AddLineVertSeries.html to draw a vertical dotted line on a time series chart (to "split" the chart at...

I would like to fill a combobox (Rowsource) with data that are used in for instance the XValues or Values of a Seriescollection of a...

is there a way to select a single item in the category axis and bold it

Hi, I'm putting together a plot which shows the number of days taken to complete documents against the date of completion. This is then grouped per month....

I am trying to create a three variable chart, does anyone know how to do it?, the three ones are percents, for instance, when a variable is 90%, the two other...

How can I change the page number orientation? The chart is landscape, the page number should be verticle when bound into a book?

I have 4 series on a graph and I would like to be able to change which series is displayed (i.e. 1 of 4, or 2 of 4, 3 of 4, or all 4). I would like to do it by...

I have a table (as shown below) and I'd like to do a simple line plot. I'd like to be able to plot this with linear x and y axes with the data points as shown...

I have a pie chart with a "3-D visual effect" and want to change the color scheme. Can this be done and, if so, how? What I am getting now is shades of...

Good day, I have observed an interesting problem with Excel 2003, in that the excel charts (any type) do not update when the source data is changed when one...

I have a data series with some missing data. Those cells are blank. When I create a trend line it reads the blank cells as zero. How can I get a true trendline...

I have a Pivot Chart that has a text field for series, a date field for category and a number field for data items. In the charting options, I've hidden the...

HTML HEAD META NAME="GENERATOR" Content="Microsoft DHTML Editing Control" TITLE/TITLE /HEAD BODY P /P /BODY /HTML

Hi all, I was able to find Peltier's very helpful solution to creating a quadrant chart in excel. Is there a way for me to include a legend key or to add data...

I've set the scale to Max 1000 which is fine most of the time but very occasionally there will be a value of more than 1000 and for these instances I need the...

Hi All, Does anyone know of a way of saving an excel file, which will include any custom charts, add-ins used etc as a complete package, rather than having to...

In regression analysis the gradient is used for further analysis. By hiding values (coloumns) the number of points in the trend analysis varies and...

If I change the display resoution in Windows (Control Panel/Display/Settings) This appears to affect how my graphs display on the worksheet but only on a...