| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data voids chart function
I created a simple chart with two columns of data. Now, the chart icon is
grey and I can no longer create a chart on this spreadsheet. Furthermore, when I copy these data to a new spreadsheet, the chart icon goes grey and no charts can be created on that spreadsheet either even if new data are used. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data voids chart function
Hi,
Never heard of this before. However, here are two unlikely causes. 1. If you are in Edit mode the charting button becomes inoperative. 2. If you are looking at the Pivot Table Charting button, it becomes inoperative whenever you are not in a pivot table. The Pivot Table Charting button looks identical to the Standard toolbar's Charting button except that it only becomes active when the cursor is in a pivot table. -- Maybe this will help, Shane Devenshire Microsoft Excel MVP "HighFlier22" wrote: I created a simple chart with two columns of data. Now, the chart icon is grey and I can no longer create a chart on this spreadsheet. Furthermore, when I copy these data to a new spreadsheet, the chart icon goes grey and no charts can be created on that spreadsheet either even if new data are used. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data voids chart function
Shane,
What is the "Edit mode"? With regard to the pivot table, I am definitely dealing with the charting function. I have the same inoperability when I display the chart toolbar. "ShaneDevenshire" wrote: Hi, Never heard of this before. However, here are two unlikely causes. 1. If you are in Edit mode the charting button becomes inoperative. 2. If you are looking at the Pivot Table Charting button, it becomes inoperative whenever you are not in a pivot table. The Pivot Table Charting button looks identical to the Standard toolbar's Charting button except that it only becomes active when the cursor is in a pivot table. -- Maybe this will help, Shane Devenshire Microsoft Excel MVP "HighFlier22" wrote: I created a simple chart with two columns of data. Now, the chart icon is grey and I can no longer create a chart on this spreadsheet. Furthermore, when I copy these data to a new spreadsheet, the chart icon goes grey and no charts can be created on that spreadsheet either even if new data are used. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data voids chart function
Did you change the workbook status to 'Shared'? Have you selected multiple
sheets? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "HighFlier22" wrote in message ... I created a simple chart with two columns of data. Now, the chart icon is grey and I can no longer create a chart on this spreadsheet. Furthermore, when I copy these data to a new spreadsheet, the chart icon goes grey and no charts can be created on that spreadsheet either even if new data are used. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can i use the IF function in a chart to choose its data series? | Charts and Charting in Excel | |||
| How do I chart a function (equation) in excel; not a data series? | Charts and Charting in Excel | |||
| chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
| How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
| Chart data file lost - need to re-create from chart? | Charts and Charting in Excel | |||
Linear Mode
