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
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
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.