excel 2007
Home > IT Answers > Microsoft Windows > excel 2007
Lisa100
5 pts.
0
Q:
excel 2007
Microsoft Excel, Excel 2007, Excel Charts
I am trying to use non-adjacent ranges to setup a clustered column with 3D visual effect option by pressing the ctrl key and selecting my ranges and every time I get the box saying one can't use the chart with information selected, what am I doing wrong?
ASKED: Nov 18 2008  9:48 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
BobBeechey
385 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
I can only assume you used ctrl ket to select FIRST area of non-adjacent ranges. This will not work as Excel will also include whatever cell was active before this selection and thus the final selection will be non-graphable. If first range is selected normally and then subsequent non-adjacent ranges are selected using the control key, then the creation of column graph will work. Alternatively press SHIFT-F8 after initial selection and then select other ranges.
Last Answered: Nov 20 2008  10:23 AM GMT by BobBeechey   385 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0