User reports that he has 4 charts created in Excel 2007 (line charts); Has issue with one of the charts when "save as PDF file". The colored background won't...

Every other worksheet my charts auto update, except one. Of course it's one that changes often... the data on the chart sheet updates, but the chart doesnt....

I have 8 bars that represent 0% to 100% standing vertically. I want to have a line drawn horizontally that is at the 80% mark. Is there an easy way to add...

I'm using VBA in Excel 2007 to plot time series as line charts (i.e., data on Y axis, dates on X axis, ChartType = xlLineMarkers). My data's not in a neat...

Hi, I have department wise and month-year wise sales data. I would like to generate a graph that allows me to show in stacked form for each month the data...

Hi, How can I plug in macros behind charts? If I double click (or single click) on a chart, I want it to execute some macros. Is it possible? For example,...

What does VIF stand for in Excel when regression outputs are being charted using Mega Stat?

Hi, I am working on a staff sales chart & that compares 2 years worth of data on a month by month basis for 4 staff. I was wondering how I could have 2...

I am preparing a template that will be used by many of our sites to prepare a monthly Cost of Poor Quality chart. This is a stacked bar chart that depicts...

I have an excel spreadsheet with graphs on the same sheet. I have had them for 8 years. This month, when I went in to update the data (updating the charts) I...

Sub Macro5() ' ' Macro5 Macro ' Macro does not change title of second chart TitleName = "Stripper Well Survey - " ...

Hi, i have a button command that brings a embedded chart onto my worksheet, it works fine, so i wanted to write a simple marco to asighn to another button to...

I track expenses in Excel. I have columns for various categories of expenses, and a single column for departmental income. When I create a pie chart to...

Sub Macro8() ' ' Macro8 Macro ' Macro does not change Series references TitleName = "Stripper Well Survey - " Windows("StripperWellsMod.xls").Activate ...

Hi, Used to be as easy as recording a macro and seeing how to do it, god knows why microsoft chose to drop this useful feature... c'est la vie. I have a...

Does anyone know how to format a line using excel 2007 built in presets via vba, as the macro won't capture them? Thanks and regards, Mark

I am doing a project ion school and i have to make a population pyramid. I have filled out all the data with males being negative. I have the chart Wizard up...

I've written a VBA macro that performs repetetive calculations in an Excel worksheet. Data from the spreadsheet is displayed in an embedded chart (X-Y...

Hi, I need to set up a bar chart that shows when and what kind of work we do for different projects throughout the year. What i would like is for the bars...

Is it possible for a Pie Chart to shows the actual value each slice represents, and not the percentage of that value to the total?