Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2003 vs 2007 Chart problem
When using Excel 2003 I asked this question:
"I have a sheet with 2 charts which get their data from some calculated cells that I'd really like to hide, but when I hide them, the chart dissappears. Even making the columns 0 width does this" ....and this was the answer that worked for me: "You need to change the properties of the chart object. Hold the SHIFT key whilst selecting the chart. This should give you a set of white square handles. Press <CTRL+1 to bring up the format dialog. On the Properties dialog select the option Do not move & size with cells. Now when you hide the columns the chart should remain in view. But, you may find the data in the chart vanishes. In which case select the chart and use the menu Tools Options. On the Chart tab uncheck the Plot visible cells only" However if I use these key strokes in 2007 I don't get the same. Am I doing something wrong or did this cange? Thanks Neil |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2003 vs 2007 Chart problem
Hi,
For 2007 select the chart. On the Format Tab in the Size group click the dialog launcher (arrow bottom right). This will bring up a dialog so you can adjust the size and move properties. On the Design tab in the Data group click Select Data. There is a Hidden and Empty cells button on the select source data dialog. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "neil40" wrote in message ups.com... When using Excel 2003 I asked this question: "I have a sheet with 2 charts which get their data from some calculated cells that I'd really like to hide, but when I hide them, the chart dissappears. Even making the columns 0 width does this" ...and this was the answer that worked for me: "You need to change the properties of the chart object. Hold the SHIFT key whilst selecting the chart. This should give you a set of white square handles. Press <CTRL+1 to bring up the format dialog. On the Properties dialog select the option Do not move & size with cells. Now when you hide the columns the chart should remain in view. But, you may find the data in the chart vanishes. In which case select the chart and use the menu Tools Options. On the Chart tab uncheck the Plot visible cells only" However if I use these key strokes in 2007 I don't get the same. Am I doing something wrong or did this cange? Thanks Neil |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
2003 vs 2007 Chart problem
On 7 Sep, 08:33, "Andy Pope" wrote:
Hi, For 2007 select the chart. On the Format Tab in the Size group click the dialog launcher (arrow bottom right). This will bring up a dialog so you can adjust the size and move properties. On the Design tab in the Data group click Select Data. There is a Hidden and Empty cells button on the select source data dialog. Cheers Andy -- Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info"neil40" wrote in message ups.com... When using Excel 2003 I asked this question: "I have a sheet with 2 charts which get their data from some calculated cells that I'd really like to hide, but when I hide them, the chart dissappears. Even making the columns 0 width does this" ...and this was the answer that worked for me: "You need to change the properties of the chart object. Hold the SHIFT key whilst selecting the chart. This should give you a set of white square handles. Press <CTRL+1 to bring up the format dialog. On the Properties dialog select the option Do not move & size with cells. Now when you hide the columns the chart should remain in view. But, you may find the data in the chart vanishes. In which case select the chart and use the menu Tools Options. On the Chart tab uncheck the Plot visible cells only" However if I use these key strokes in 2007 I don't get the same. Am I doing something wrong or did this cange? Thanks Neil- Hide quoted text - - Show quoted text - Cheers Andy. 2007 was supposed to be easier! That was tucked away compared to 2003!!! Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2000/2003 Chart Not Visible In 2007! | Excel Discussion (Misc queries) | |||
2000/2003 Chart Not Visible In 2007! | Charts and Charting in Excel | |||
Excel 2007 Auto Login Problem worked with 2003 | Excel Discussion (Misc queries) | |||
How do I make a combination chart in 2007 as in 2003? | Charts and Charting in Excel | |||
Office 2007 / 2003 compatibility problem | Excel Discussion (Misc queries) |