Hi, I have a stacked column chart with three colors on all three columns, created automatically with code. When the column is small, the labels come upon each...

When using Excel to produce forms, I want to automate how the cells are selected when inputing data. Usually, I unlock the cells that will have data entered...

Hi, I have some charts that I want to remove only the data labels which value = 0. I know how to do this manually,I am only interested in finding out how to...

Several Excel charts. 25-month period. Each month a data point. Only 1st, middle and last data points labeled. As data is updated each month, the data labels...

I am using MS Excell to make bar graphs which I then import into a Corel Presentation WPG file. I am doing this using the clip board, inserting the graph as an...

Hey, I automatically want the range of a chart to be adjusted to the max and min values of Series1 (only one series, not all of them). I adapted the ms...

In Excel 2003, on a print preview of a chart sheet, when I move the margins around, the chart automatically scales itself. e.g. if there are 3 columns and I...

I've got a sheet that records a date/time and a value next to the time. I've got a xy scatter chart that plots the date/time the data was entered (x values)...

I am managing a database of lab results for an external company. That compnay recently upgraded from Excel 2003 to Excel 2007, which resulted in the...

Hi John we started communicating on 2/7/2009 about problems I am having with Excel 2007 re the automatic swap of x - and y - axis. I am just wondering...

Hi folks, I need to call upon the experts here for a problem that has left me scratching my head. I have opened an existing Excel file that has a line chart...

I have a chart I want to automatically update from now until a certain point in the future. The chart actually updates, but shows the whole time series (but...

I would like the chart to update automatically when monthly data is entered. Every 1st of the month I update the data to add previous monthly values. I like...

Hello, I am looking for a way to update my chart's source data automatically on a daily basis. Each day a new row is added to my chart, therefore I have to...

I have created a chart that should automatically update. However, some of the more recent data is not being displayed. The OFFSET formula seems to...

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...

I have a chart displaying 2 years worth of data – each month is a data point. I want to automatically drop the oldest data point and add the newest when I...

Just wondering if I could automatically change a chart. For example I do a number of chart for every month, obviously days of the months changes so on a month...

In Excel 2003 I used scroll bars to set the limits on a dynamic range of my chart. Basically, I used to "zoom in" on a particular section of the chart. The...

I have about 100 graphs that need updating each month and I want to find a way that I don't have to go into each of them to extend the range manually. THe...