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
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
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
What happens if its a column chart? Surely an "x" value can be recorded.Originally Posted by Dave
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link