I have a column in my source data called "TIER" so the values are 1, 2, 3 etc. when I convert to a pivot chart I want those values/bars to be automatically &...

I've searche dthis forum and found the following link (http://www.andypope.info/charts/polarplot.htm) which provides an addd-in for polar plots. My question is...

I have 3 individual cells that automatically update every second: 1)Time; 2) Implied Price; 3) Actual Price. I track the changes of the Implied Price against...

How to create a "Today's date" verfical line on a chart that moves with date change?

I have a chart that has dates, (month,year) as the y axis from 1/2003 thru 4/2006. The x axis is 3 of 15 (top 3) of a series of data. My question is can the...

I have some data I need to plot in a column chart The variable activeE6 has three columns that show small (49%) med (33%) and large (19%) The variable...

Hi All, I've made a Waterfall chart once (actually Jon did ... ) ..but I deleted an individual data label of a certain series. Now I would like to get it back...

I am working on documentation within Excel. I have copied several flowchart shapes that I use a lot. Some of them will not show within the clipboard I have...

This is probably a very easy question I just haven't spent a lot of time with Excel charts. How do you change the style of 1 gridline on a chart? The data on...

There is a bug in Excel 2007 Beta 2. In the legend for the chart if the Series Name value is set equal to a cell and that cell is hidden then the Series Name...

I want to draw a graph compairing the turnover with the years taken to achieve the same by different coompanies

How can one gridline be edited to change colour in ad 3d bar chart. Thanks in advance for your help.

Excel 2002. A macro (Bebington) copies information from 1 sheet to another from which a line chart is created. It truncates the last series ( although the data...

I've made a XY scattergram that I want to copy for use to other workbooks with other data series. The exact part of the data series to be displayed in the...

Hi, I have an ordinary Excel line chart, but there are 30 data series on it. Is there a quick way to format each line the same, eg blue with no individual data...

When I create a chart in Excel 2007 that is its own sheet, I cannot view it. As soon as I move my mouse over top of it my entire screen goes entirely blank. It...

I have a graph of the revenue for the last 24 months. I added a trendline to give me the next months. Can I get the exact value of the those trends for the...

Does anyone know a way to freeze pivot chart FORMAT, while allowing data updates?

Okay, I've been hammering away at this for days now, and I *still* just do not get it. I've been _trying_ to use the user-defined function created by Andy...

In order to adjust the spacing of a scatterplot line away from the Y axis, I use a custom number format (applied to the axis) to hide the first (nonploted)...