| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I select individual cells for a chart
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!! |
|
#2
|
|||
|
|||
|
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/ _______ micachou wrote: 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!! |
|
#3
|
|||
|
|||
|
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. "Jon Peltier" wrote: 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/ _______ micachou wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select a range using "cells()" | Excel Worksheet Functions | |||
| select a chart without the selector handles showing? | Charts and Charting in Excel | |||
| Select format cells Custom but Saves As Specil Why. | Excel Worksheet Functions | |||
| what allows me to select cells for use in a formula by using a mo. | Excel Worksheet Functions | |||
| Strange Problem with Chart and Plot Visible Cells Option | Charts and Charting in Excel | |||
Linear Mode
