PDA

View Full Version : Enter seperate cells in chart



Tenspeed39355
05-14-2009, 04:37 PM
Hi guys What is the formula for entering seperate cells in an Excel chart?
$A$3 $B$4 $D$2? Thanks for any help on this one.
Max

Dave
05-15-2009, 05:04 PM
Seperate cells? Max, I don't think I understands what your trying to do. Care to add some more info. Usually charts represent cell pairs... "X" and corresponding "Y" values. Three cells seem hard to chart. Dave

Tenspeed39355
05-15-2009, 06:42 PM
Dave Thanks for the reply. Example: Can I put $A$3, $C$3, $E$3 in a chart?
There is some data in column B,D that I do not want to show in the chart.
=Sheet1!$A$3,$C$3,$E$3. I know this does not work so you have a way to enter the cells? Thanks for your help
Max

Dave
05-16-2009, 06:55 AM
Max... what type of chart AND you need BOTH "X" values and "Y" values to make a chart. Where are they located. If you want to omit some values from a series, change there value to #n/a. Dave

Aussiebear
05-16-2009, 02:46 PM
Max... you need BOTH "X" values and "Y" values to make a chart.

What happens if its a column chart? Surely an "x" value can be recorded.