I want to make a graph that will expand and condense anytime that new information is inserted into a linked worksheet. What happens now is that the graph...

does anyone know how to format a pivot table so there are no blank cells? see below I curently get type A X 12 Y 20 Z 32 type B ...

I would like to produce a recordset on my server (VB6) then in Excel produce a range of data. (client-server application) (RS is the usual way in this...

Is there any way in which I can do the following: I have 5 companies, each have a rate for month 1 & 2, for=20 5 models. I would like to show the...

Is there a way to close the gap in a mixed bar/line chart so the line extends closer to the edge of the chart?

Hi from Loucas, This is my second posting to the forum. I hope someone out there can help me! I am trying to set the data range for my chart automatically....

I would like to create a chart that plots high/low bars (ie stock chart) and overlay that information with scatterpoints. Basically, plot stock movement and...

Im trying to create a bubble graph (still the same ones really) that when you double click on one of its points it creates a list (probably in a new sheet) of...

Hi, How to make excel omitt zero values instead of displaying 2 or more zero values in one place on pie chart when some of values in source data range...

Is it possible to use a series of cells for the data labels on a scatter chart ? For example, x values in column A, y values in column B, and data marker...

Hi I am charting data which may have several entries in the same month. I thought by changing the Base Unit from Days to Months it would summarise on a...

I want to chart sales in units over time for multiple products. The products have sales for 2-4 days each week, so for example, Mon Wed and Fri might have...

I have one chart who's data changes based on selections made. Sometimes the data is a number formatted with zero decimal places and a comma (ie 1,900). ...

I have a scattered chart with a name column and another two columns with the data to plot the charts. I am unable to mark those points with the corresponding...

I want to run a loop which will set the data source of all piecharts in a single worksheets. Source of Chart1 is in Cells(5,3) and Cells(5,4) Source of Chart2...

Hi have a look at http://www.tushar-mehta.com/excel/newsgroups/broken_y_axis/index.html http://peltiertech.com/Excel/Charts/axes.html#Broken -- Regards Frank...

I would like to develop a partial logarithmic X-Y scatter chart. My X-axis data is frequency data from Minimum of 10Hz to a maximum of 2000Hz. However,...

Where do you go in Excel 2003 to format a data series from a column to a line? I don't see that as an option in fomat data series.

Is there a know way to paste a chart into a new workbook as a jpeg/png using paste special if the chart was created with autofiltered data? Currently, paste...

Hello All, I’m trying to re-use a Chart Object to dynamically display different sets of data, using VBA. To clear the chart of one data set, before...