How do I select individual cells for a chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

micachou - 29 Jul 2005 11:16 GMT

I am trying to select individual cell values for my chart but the dialogue
box will only allow a certain number of characters therefore I cannot select
all the cells I want.
Help!!

Reply to this Message

Jon Peltier - 29 Jul 2005 12:35 GMT

One of the most important tasks in making a chart is to properly prepare
your data. One data feature that improves charting is having all plotted
cells together in a single range.

If it's not a dynamic selection of cells, you could select the cells
(use ctrl+click to select multiple discontiguous ranges), then paste
them into an empty range.

If your range is changeable, note that by default Excel charts do not
display information from hidden rows or columns. You could manually hide
rows or columns, or use the AutoFilter to hide rows.

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

> I am trying to select individual cell values for my chart but the dialogue
> box will only allow a certain number of characters therefore I cannot select
> all the cells I want.
> Help!!

Reply to this Message

micachou - 29 Jul 2005 12:47 GMT

Thank you that will be useful for the future.

I realised that the reason there was no room was because the sheet tab
description was very long. I renamed the tab to letter A then selected my
cells for the graph. Once it accepted this I renamed my tab.

> One of the most important tasks in making a chart is to properly prepare
> your data. One data feature that improves charting is having all plotted
[quoted text clipped - 20 lines]
> > all the cells I want.
> > Help!!

Reply to this Message