I have written some custom macros in previous versions of Excel that count on the ability to be able to select data points in a Scatter Plot and move them in...

I am creating a dynamic chart that captures 24 months of data. I'm using a vlookup to put data into the cells and it goes out 5 years. It looks like the...

I have a simple xy chart with months on the xxis. I am collecting data as every month goes by. Is there a way to chart all 12 months on X axis and the Y axis...

I am working on a bar chart that lists the # of schools on the x axis and total sales on the y axis. Since there are numerous schools, I noticed the colors...

I have some code that set the range for two series charts on one worksheet. The charts are embedded on a worksheet, and the ranges xV, xX and xT are set...

Sorry but I must be missing something. I'm with you until "Axis Options", but under "Axis Options" I don't see anything that says "Axis Type" or anything...

Trying to write a macro that will do a 'search and delete' type function for cells that yield a "DIV/0" error. What I want to accomplish is a break in the...

I have spreadsheet developed in Excel 2003 inserted a calendar control in a spreadsheet so I could easily click on the date and evaluate data from that date....

I am trying to have my chart titles auto populate with both text and a reference field. I want the title text box to read "Text 'contents of a referenced...

using the stephen bullen scroll/zoom barchart example, i'd like to do the same with an xy scatter chart, with 12 columns of data. I can get my graph working...

Hi everyone, I was hoping to be able to use the camera tool to copy the legend box to use for a series of graphs that will be displayed together to make the...

Hi, in excel 2003 I had no problem with this issue. I am building a stacked bar chart, diplaying values for two years, on a series of categories each...

I am trying to create a pie chart using basic, but changing data (sometimes the value can be zero) When it is zero, I do not want it to show Blue 0 Red ...

When I copy a chart/ graph from excel 2007 and paste it into a word doc it changes the format (i.e., makes it too big or cuts off some of the graph or...

I'm trying not to whine, however, amongst the many problems and frustrations in making the transition from the current Office environment to Office 2007, we...

I have an excel pivot table that uses Access as the data source, the file is on the network drive "m" at work. Does anyone know how to change the path of...

Can anyone tell me if there is a way to set rgb colors in excel charts? thanks so much for your help.... thanks - Cindy

I've got a bar chart (the lines flow left to right) that i update every week...the current bar chart i'm using has some sort of conditional formatting where...

How to colntrol location of category X axis labels on a bar chart? usually data have only positive values, category X axis labels are in the left side of...

I am creating a scatter chart that is designed to show trends in employee performance. Employees are rated with 2 different tools, each using a 5 point...