Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Some questions about Excel 2007 Charts
1. In Excel 2003, the line chart won't draw the value of #N/A and
leaving it as an empty point. but in Excel 2007, it deal the value of #N/A as zero. In such condition. I could not drawing some conditional charts which could associate different scopes of value with different series and format them differently. 2.the dynamic chart in Excel 2007 seems to be disappointed, I could not combine the chart with form control. and the relative reference names( such as data1=OFFSET(Sheet1!$B11,0,0,1,COUNTA(Sheet1!$1:$1 )-1) could not function too. maybe you could find it by the sample of John Walkenbach's "define series based on active cell - F9.xls". 3.The mouse's double-clicking function couldn't work too. I used to format chart element by double-clicking it and set the format options in its format dialog box. but now I have to rely on ribbon or right- clicking pop-up menu. and the other questions is still there too. Could you give me any suggestion, Thanks in advance. Yours,fujing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbar questions in 2007 | Excel Discussion (Misc queries) | |||
charts are not visible in excel 2007 | Charts and Charting in Excel | |||
Couple of Office 2007 questions | Excel Discussion (Misc queries) | |||
2 Questions about Excel Charts | Charts and Charting in Excel | |||
EXCEL Hyperlink to Charts Questions.. URGENT.. =( | Excel Discussion (Misc queries) |