Hi all, Can someone tell me how to add non-contiguous data to a chart. My data is in B21, G21, L21........IR21. Ideally, the chart would auto-update to...

Hi All: I am printing Excel charts--both embedded and as chart sheets--to a plotter on Arch C setting, but I always end up with about 6 inches of blank space...

I'm trying to format labels (both axis and data) to include subscripts in Excel 2003 and can't find a way to do it. I can change the label to be ENTIRELY in...

I understand that you can automatically refresh data that has been imported from an external source into your excel file, but how do you automatically...

I need to place a excel table into my chart which cells will contain sumif formula based on forecasted data (changes monthly).

I want to display data on a radar chart using bubbles but can't figure out how to do this in excel. Is it possible or is other software needed, if so, any...

How can I reset my pivot chart 'search field' ? After I updated some data from within the master sheet I am still seeing the information I deleted out of...

I have charts which automatically display a rolling 30 days of data. I want the new day's data to be the right column and the oldest day (31 days ago) to...

As soon as I draw an object in my chart and click off it, it vanishes. I know there was someone else with this same problem and it sort of resolved itself...

I have installed Excel 2007, and I can't create any chart, the message "Some chart types cannot be combined with other chart types. Select a different chart...

If i Want excel to restrict the No. of Columnin the sheet to only Three (A B C) the rest Invisible then how do i do that

Hi, I have a worksheet with 52 work weeks on it. Each week I enter in new data and I want my graph to update for the latest 13weeks.... Does anyone know how...

Excel 2007 seems to have corrected some probs with previous versions e.g., you can now use a base other than 10 on a value axis. Does anyone know what...

I need to do the same thing to every series on a chart. Some of my charts have 8 to 10 series lines drawn on them. I know how to write a loop, but I don't...

A title on my chart clearly would fit on one line, but Excel does not use the full width of the chart area for the title. Is there a way to fix this...

I do not use the chart/grph feature too often. I was trying to use the Chart Wizard to graph the following...

I have an Excel sheet with many rows with subtotals in between. I wish to graph the subtotals without including the data that created the subtotals. I have...

Is it possable to make a chart with a fixed range on the side and bottom as if it was printed? if so how do we do it, I'm using office 2007 but also have...

I want to "record" a macro that, for example, changes the line styles on an Excel chart. I tried by selecting the chart, then clicking on "record macro",...

When I hit "refresh data", my chart go to default color. How can I avoid this by writing a simple macro and assign to every worksheet? Thnks Daniel