ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why is Insert Chart (mis)behaving this way? (https://www.excelbanter.com/excel-discussion-misc-queries/159366-why-insert-chart-mis-behaving-way.html)

[email protected]

Why is Insert Chart (mis)behaving this way?
 
Using, when I right-click on the tabs and select Insert Chart, I get a
blank chart. But just now -- and for several attempts -- Insert Chart
is creating a chart that uses several columns of data in the current
worksheet, even though they are not selected.

Why is Insert Chart (mis)behaving this way? More importantly, how can
I restore the previous behavior (a blank chart)?


Jon Peltier

Why is Insert Chart (mis)behaving this way?
 
I've never used this trick to insert a chart. I guess I learned first to
select a blank cell within a blank range, then press the F11 function key.

I tried your method, and since it worked as expected (blank chart), I have
no comment.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
oups.com...
Using, when I right-click on the tabs and select Insert Chart, I get a
blank chart. But just now -- and for several attempts -- Insert Chart
is creating a chart that uses several columns of data in the current
worksheet, even though they are not selected.

Why is Insert Chart (mis)behaving this way? More importantly, how can
I restore the previous behavior (a blank chart)?





All times are GMT +1. The time now is 02:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com