Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
show / hide chart data
How do I add a button to hide/show a data series in my log or semi log chart.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
show / hide chart data
You could hide the row/column that contains data for that series. Record a
macro while doing it manually to get the code. You could also try one of these techniques: http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim" wrote in message ... How do I add a button to hide/show a data series in my log or semi log chart. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
show / hide chart data
Thanks Jon, I'm working on your exapmles.
Now that I see your reply, I have to ask another question: I am plotting the average of the data points over my raw data (to show a smoothed 'trend' curve), so will I be able to show this when the data series is hidden? I'd like to hide the raw data and show the smoothed, to summarize. Thanks, Jim. "Jon Peltier" wrote: You could hide the row/column that contains data for that series. Record a macro while doing it manually to get the code. You could also try one of these techniques: http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim" wrote in message ... How do I add a button to hide/show a data series in my log or semi log chart. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
show / hide chart data
Jim -
If you set up another range with the smoothed data, and don't hide it like the other series, it will appear in the chart. Charting one series is independent of the others. Not charting a series doesn't make the smoothing calculations not work. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim" wrote in message ... Thanks Jon, I'm working on your exapmles. Now that I see your reply, I have to ask another question: I am plotting the average of the data points over my raw data (to show a smoothed 'trend' curve), so will I be able to show this when the data series is hidden? I'd like to hide the raw data and show the smoothed, to summarize. Thanks, Jim. "Jon Peltier" wrote: You could hide the row/column that contains data for that series. Record a macro while doing it manually to get the code. You could also try one of these techniques: http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim" wrote in message ... How do I add a button to hide/show a data series in my log or semi log chart. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
show / hide chart data
That is excellent. You are an excellent resource! I found your web site very
useful. Finally, can you explain the references in the formula you suggest "=IF(C$3,C6,NA())" so I can understand and apply to my data a bit more intuitively as my columns don't line up the same. Is it a simple matter to copy the buttons to the chart worksheet, while the data remains on another? -Jim- "Jon Peltier" wrote: Jim - If you set up another range with the smoothed data, and don't hide it like the other series, it will appear in the chart. Charting one series is independent of the others. Not charting a series doesn't make the smoothing calculations not work. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim" wrote in message ... Thanks Jon, I'm working on your exapmles. Now that I see your reply, I have to ask another question: I am plotting the average of the data points over my raw data (to show a smoothed 'trend' curve), so will I be able to show this when the data series is hidden? I'd like to hide the raw data and show the smoothed, to summarize. Thanks, Jim. "Jon Peltier" wrote: You could hide the row/column that contains data for that series. Record a macro while doing it manually to get the code. You could also try one of these techniques: http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim" wrote in message ... How do I add a button to hide/show a data series in my log or semi log chart. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
show / hide chart data
C$3 contains a T/F for column C; without the $ in front of C, when you copy
the cell to another column, say one column to the right, the formula becomes =IF(D$3,D6,NA()). You have to make adjustments for the shape of your data, of course. The formula looks at the T/F, and if it's true it shows the value from cell C6, if it's false it shows #N/A, which will not be plotted in a line or XY chart. The 6 in C6 has no $ in front, so if you copy the cell down a row it will change to C7. Check for a web page that describes relative and absolute references, like Chip's for example: http://cpearson.com/excel/relative.htm You should be able to copy the controls to the chart sheet. You can only use Forms toolbar controls on a chart, not the Controls Toolbox (ActiveX) ones. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim" wrote in message ... That is excellent. You are an excellent resource! I found your web site very useful. Finally, can you explain the references in the formula you suggest "=IF(C$3,C6,NA())" so I can understand and apply to my data a bit more intuitively as my columns don't line up the same. Is it a simple matter to copy the buttons to the chart worksheet, while the data remains on another? -Jim- "Jon Peltier" wrote: Jim - If you set up another range with the smoothed data, and don't hide it like the other series, it will appear in the chart. Charting one series is independent of the others. Not charting a series doesn't make the smoothing calculations not work. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim" wrote in message ... Thanks Jon, I'm working on your exapmles. Now that I see your reply, I have to ask another question: I am plotting the average of the data points over my raw data (to show a smoothed 'trend' curve), so will I be able to show this when the data series is hidden? I'd like to hide the raw data and show the smoothed, to summarize. Thanks, Jim. "Jon Peltier" wrote: You could hide the row/column that contains data for that series. Record a macro while doing it manually to get the code. You could also try one of these techniques: http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim" wrote in message ... How do I add a button to hide/show a data series in my log or semi log chart. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
show / hide chart data
Well, it works nicely but the smoothed data follows the show / hide check box
function. For some reason they are not independant. Can I send you the sheet, or some more of the cells? -Jim- "Jon Peltier" wrote: C$3 contains a T/F for column C; without the $ in front of C, when you copy the cell to another column, say one column to the right, the formula becomes =IF(D$3,D6,NA()). You have to make adjustments for the shape of your data, of course. The formula looks at the T/F, and if it's true it shows the value from cell C6, if it's false it shows #N/A, which will not be plotted in a line or XY chart. The 6 in C6 has no $ in front, so if you copy the cell down a row it will change to C7. Check for a web page that describes relative and absolute references, like Chip's for example: http://cpearson.com/excel/relative.htm You should be able to copy the controls to the chart sheet. You can only use Forms toolbar controls on a chart, not the Controls Toolbox (ActiveX) ones. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim" wrote in message ... That is excellent. You are an excellent resource! I found your web site very useful. Finally, can you explain the references in the formula you suggest "=IF(C$3,C6,NA())" so I can understand and apply to my data a bit more intuitively as my columns don't line up the same. Is it a simple matter to copy the buttons to the chart worksheet, while the data remains on another? -Jim- "Jon Peltier" wrote: Jim - If you set up another range with the smoothed data, and don't hide it like the other series, it will appear in the chart. Charting one series is independent of the others. Not charting a series doesn't make the smoothing calculations not work. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim" wrote in message ... Thanks Jon, I'm working on your exapmles. Now that I see your reply, I have to ask another question: I am plotting the average of the data points over my raw data (to show a smoothed 'trend' curve), so will I be able to show this when the data series is hidden? I'd like to hide the raw data and show the smoothed, to summarize. Thanks, Jim. "Jon Peltier" wrote: You could hide the row/column that contains data for that series. Record a macro while doing it manually to get the code. You could also try one of these techniques: http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim" wrote in message ... How do I add a button to hide/show a data series in my log or semi log chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated show and hide chart | Charts and Charting in Excel | |||
Show and hide a embedded chart? | Charts and Charting in Excel | |||
How can I show/hide plots in a chart? | Charts and Charting in Excel | |||
Chart Legend Items: hide/show | Charts and Charting in Excel | |||
hide column but show chart | Charts and Charting in Excel |