Hello all: In the same workbook I have several charts generated by pivot tables. In one chart the data labels are at location "Outside end". In the others...

Here is my data: Location Flowers Trees Year 1 Year 2 Year 1 Year...

Hi all How can I create a Statistic Process Control chart with 3 sigma Upper control limit and 3 sigma Lower control limit. The chart must be updated with...

Hi I'm having problems with graphs created in 2003 version, when these open in 2007 the Horizontal axes and text goes completely wrong! Any ideas where to...

i want to produce a linear-log graph in excel (that means linear scale in y-axis and log scale in x-axis)...however, the only form that i can draw a graph is...

I'm writing a macro in which the user has to choose 2 value on a bar-graph. I can trap chart events as Jon Peltier say (...

Hello, I have data as follows: M L G Y Jan 5 7 8 2 Feb 4 7 1 4 Mar 8 4 4 9 Apr 3 5 7 1 I...

I am using the macro below to set the axis minimums, maximums, and major units for a series of charts. I would like to tie this macro to RefEdit controls,...

I have a form I created in VB and it facilitates data entry into a spreadsheet. Once I fill out the textboxes and click ok, it inserts a new row into the...

Hi I want to to create a chart where the colour changes when ever a value is reached. Ex. I have a mashine that produces 1000 it's goal is 2000. The chart...

I'm using a stacked bar graph and would like to align the x axis label with the edge of each column instead of having the label centered on each column.

Does anyone know how to create the notches in the vertical box whisker charts? An example can be found in figure 10 of the following...

http://peltiertech.com/Excel/Charts/statscharts.html How can this dynamic control chart is made. Need step by step instruction Thanks Daniel

Hi Folks - I have the following data: Salaries 29% Programs 71% dept1 9% dept2 61% dept3 30% Dept1, 2 and 3 are...

Has anyone else found an error in the trendline tool in excel 07? I found that when transforming the x axis to logarithmic, the trendline stays linear, when...

I am just learning to use Excel charts and need some assistance -- I want to show goals versus acutal on a horizontal bar chart and i cannot figure out how...

Using Excel 2003 I created one pie chart and then did a copy & paste to paste that same chart into another worksheet. Then I right-clicked and chose...

Hi, I have a worksheet with about 8 charts on it. On all but 1 chart, when I delete the Chart Title, the plot area expands. Can anyone tell me why this...

I'm trying to "square" a chart... I mean: given 2 points (P1 and P2) with coordinates P1(x1,y1) and P2(x2,y2), I want set the vertical (y) distance between P2...

I need to make a series of charts that depend on a column in my datasheet. What I mean is this - I have data laid out per below, that is logged by operators...