Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hidden Data to show on the Chart
Hi all, I have a spreadsheet with one TAB holding all my data, and a second TAB holding my Chart. The spreadsheet grows and grows by the column, the rows are pretty much fixed. Since the spreadsheet gows horizontally, I hide a lot of the earlier columns for ease of maintenace. I have created line charts for a couple of rows. My problem is, I want the chart to chart on all the data, including the hidden data, however when I hide say 20 columns, those columns are no longer represented on the chart - unhide them and they reappear on the chart. Is there any way of ensuring the chart uses the data specified regardless of wether the data is hidden or not. Thanks in advance. -- Brisvegaslad ------------------------------------------------------------------------ Brisvegaslad's Profile: http://www.excelforum.com/member.php...o&userid=26171 View this thread: http://www.excelforum.com/showthread...hreadid=394885 |
#2
|
|||
|
|||
Hi,
Select the chart and then via the menus Tools Options go to the Chart tab. Here is an option to plot visible cells only, which you can unselect. Cheers Andy Brisvegaslad wrote: Hi all, I have a spreadsheet with one TAB holding all my data, and a second TAB holding my Chart. The spreadsheet grows and grows by the column, the rows are pretty much fixed. Since the spreadsheet gows horizontally, I hide a lot of the earlier columns for ease of maintenace. I have created line charts for a couple of rows. My problem is, I want the chart to chart on all the data, including the hidden data, however when I hide say 20 columns, those columns are no longer represented on the chart - unhide them and they reappear on the chart. Is there any way of ensuring the chart uses the data specified regardless of wether the data is hidden or not. Thanks in advance. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Thanks very much Andy, issue solved. :) -- Brisvegaslad ------------------------------------------------------------------------ Brisvegaslad's Profile: http://www.excelforum.com/member.php...o&userid=26171 View this thread: http://www.excelforum.com/showthread...hreadid=394885 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fan charts | Charts and Charting in Excel | |||
How can I show data under a Chart that I inserted in a worksheet? | Charts and Charting in Excel | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
hide column but show chart | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |