How do I change the default chart colors in Excel 2007? Thanks, Gene

I am preparing a bar chart and want the data displayed as round thousands The chart data is in whole numbers. How do I do this?

I'm using Excel 2007 I have a chart that plots data points SUMPRODUCT(--(B498:Q5340),--(B498:Q534=100)/COUNT(B498:Q534)) plus other formulas (between 101...

Any way to show series A - D in the graph and not on the data table and series E-H on the data table and not on the graph?

In Excel 2003, If you made a graph of a pivot table you would have buttons inside the graph that would allow you to make certain selections or filters inside...

Hello, I have a VB6 app that launches Excel and generates charts. Currently we use Excel 2003 but the company is finally adopting 2007. Parts of the chart...

This is really silly, but why are my charts surrounded by a border of dots, split only by the words 'chart area'. I just cannot clear it. Never have...

For some of my data I skip days for collecting it so I use the shift key to click on the days I do want in the chart. I have been doing this for awhile but...

Hi, tried psoting my reply but seems to have some problems. Press "Alt"+"F11" to open the visual basic. Then at the left you will see VBAProject (Name of...

Hi, I faced this problem and found a solution but you need to use macro. Sub AutoScaleYAxes() Dim ValuesArray(), SeriesValues As Variant Dim Ctr As...

I plotted rainfall data and river levels on an X-Y graph. I then changed the way the rainfall was displayed from a line into columns. Unfortunately, Excel...

Hi I have a stacked column graph which shows me how many people have been sick over the month and for what reason. The months are on the horizontal axis...

In excel 2007 my charts are displayed when inserted in a a sheet but they do not show when moved as separate tabs

I work in a microbiology lab. We test if bugs are Susceptible, Intermediate or Resistant to a particular antibiotic. In order to make this determination we...

I'm creating a large workbook with master data on one page and on all following pages Pivot Tables with associated Pivot Charts, one worksheet per state, 4...

I have a spreadsheet with charts, and I get a circle with a line through it when hovering over a chart. Additionally, the entire "data" tab and a good...

I was reading a post by Jon Peltier on how to overlay a floating column chart showing open/close data over a high-low line chart showing high/low data. After...

histogram total in table but not in chart

how can I change the circumference of the pie in the chart? sometimes is is a lot bigger than others and looks funny when two are compared on the same page.