It can be done but is a bit complex. The method relies on the fact that a single data point can be given colour & border that differ from other members of the...

My Y1 axis is from 0-250 my Y2 axis is from 0-9000 When graphing percentages the line shows up at the very bottom since 99% 1 is there a way I can multiply...

How do I hide/show a series on a chart legend (scatter plot.) I tried a null string (""), but the trace still shows. I also tried #N/A. But it then shows...

I am making a graph with columns, where each column represents water use on a certain time interval. I have 38 time intervals which are, each one, defined by...

I would like to graph some data - body weight for example. I would set up the date on the X-axis and the weight on the Y-axis. When inputting the data, I...

I am trying to plot an XY scatter graph with 2 series from this data: Year 1996 1997 1998 1999 2000 2001 2002 2003 National...

Hi I have a worksheet with about 150 rows and 50 columns. I would like to create a bar chart for each rows worth of data on a seperate worksheet, using the...

AAAAAAAAAAAAHHHHHHHHHHHHHHHHH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! THIS IS DRIVING ME CRAZY!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I have this buggy chart. I have a spread...

Hi, I am trying to create this chart with dates on x axis and clustered bar chart on y axis showing availability of equipment(Rented,Quoted,Available). I...

Hi, Im using a radar map to display data. I have added in a new field that is automatically inserted into radar map (where the map gets its data from). The...

I would like to be able to format a single line in a chart (representing the time period 2002 to 2010) to be solid for actual data and dotted for projected...

I would like to place bubbles on the 2D places (x,y) with different radius. The coordinates are the (column, row) an´d the rtadius the value in the...

How can I get my chart to ignore values which are zero in the series data and not show these?

I have a line graph with 6 series plotted (I.e. 6 different lines--sales on y, months of x). How do i add a best fit line to the chart? When i select...

Ive added secondary y axes before, so you can have a series relating to the left hand axis and one on the right, but with a common x axis but is there an easy...

I've been reviewing the helpful links given in this forum for dynamic charts, and I've learned a great deal. All of the links I've reviewed focus on...

I am calculating/plotting a log trendline extract on the equation y = 533371Ln(x) - 3E+06. Ln(x) is the period (extract) number, starting at 1 and ending at...

HI, I have a graph where I ask departments to rate their talent pool from 1 - 10. Then I ask them to grade their department from A+ to F. So for an xy chart x...

Hello, I was hoping somebody could help me with the following problem: I have a bunch of pie charts that simply will not update despite the fact that the...

I'm creating a mail merge in Word, using a large Excel data source. The file contains multiple names, with various associated data. I want to create an...