If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Source Data in Charts
I have a spreadsheet that I'm using to create a line
chart. It is to show daily efficiencies. I've picked the new cell each day to add to the chart and it's worked fine until today. The cells are not in order so I use the CTRL key to add a new cell each day. Today I went to do that (there are 17 different charts I'm working with) and when I selected the cell to add today, it unselected all the others. Is there a limit to the number of cells I can pick for a chart? I would think that I could have at least 30 cells worth of info in my chart? Anybody have any info or help for me? Of course I need these charts for my boss ASAP. |
#2
|
|||
|
|||
Source Data in Charts
There's a limit to the number of characters that you can enter in the
Data Range box. As a workaround, you could define the range of cells that you want to use, and enter the range name in the Data Range box. There are some instructions here for creating a named range: http://www.contextures.com/xlNames01.html Or, create a summary table on the worksheet, linked to the data, and create the chart from that table. To create a summary table, enter references to the data in a contiguous range of cells. For example, if the data for a chart is: Series1: A5, C5, E5, H5, L5, T5 Series2: A9, C9, E9, H9, L9, T9 You could create the summary table starting in cell V2: In V2: =A5 In W2: =C5 etc., to pull all the data into a contiguous range. Then, select this range, and create the chart. KABE wrote: I have a spreadsheet that I'm using to create a line chart. It is to show daily efficiencies. I've picked the new cell each day to add to the chart and it's worked fine until today. The cells are not in order so I use the CTRL key to add a new cell each day. Today I went to do that (there are 17 different charts I'm working with) and when I selected the cell to add today, it unselected all the others. Is there a limit to the number of cells I can pick for a chart? I would think that I could have at least 30 cells worth of info in my chart? Anybody have any info or help for me? Of course I need these charts for my boss ASAP. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|