| Thread | Last Post | Replies |
|
| excel2007 pivot table chart x-axis | 05 Aug 2008 19:56 GMT | - |
I make pivot table charts with multiple items on the x-axis. excel2007 seems to randomly blank out some of the x-axis numbers. excel2003 did not do this. In addition, I can open up an excel2003 file with a "normal" looking pivot table chart, but if I create a new chart in ...
|
| Pivot tables lose of data fields when selecting | 05 Aug 2008 19:00 GMT | - |
Having an issue with setting up pivot tables not to lose certain fields if users de-selects some. For example I have muliple column of data. a, b, c, d, e, f
|
| Excel 2007 - mixed type (line, column, stacked column) in one char | 05 Aug 2008 18:33 GMT | - |
I just upgraded to Office 2007 and am interested in formatting my chart to the fullest. How can I make 1 chart with several types of data. I have 8 points of data, and want to show the data in 1 chart in the following format:
|
| Problem Resetting Data Source Ranges via VBA | 04 Aug 2008 20:34 GMT | - |
I have a macro that is supposed to reset three data ranges (one X, two Y) based on the number of data rows in the current worksheet. The first two work fine, the third one errors out, saying it is "unable to set the Values property of the Series class." I'm I'm darned if I can ...
|
| restore encrypted files for original format | 04 Aug 2008 15:47 GMT | - |
I created a budget spreadsheet on Excel & saved it, however when I go to open the file all the figures are encrypted. How do I restore this file to the orinal figures.
|
| Stacked Sum From an OLAP Cube | 04 Aug 2008 11:08 GMT | - |
Lets say you have to plan capacities for two Teams per Week over two months. For each week you have got target values and actual values in hours (h). A table can look like this in 2008 for week 27 and 28: Week 27:
|
| How to stop pivot table crashing in Excel 2007 | 01 Aug 2008 23:16 GMT | - |
In a large spreadsheet with several tabs I’m having a problem with excel crashing while making a pivot table after a specific series of events happen. On the main data tab I have both several columns populated by data from an Access query and several columns populated by assorted ...
|
| what are the bubbles that appear when I click on my spreadsheet | 01 Aug 2008 17:54 GMT | - |
I am working with an excel spreadsheet that is updated weekly by email. sometimes it slows to the point of a standstill. I am wondering if the patterned bubbles are part of the problem. Regardless, how do I get rid of them im my spreadsheet?
|
| Drag Capabilities | 01 Aug 2008 07:45 GMT | - |
Guys, I seem to have lost that little plus sign that appears in the right hand bottom corner of the cell that allows for dragging formatting and content onto other cells. Help in the this would be greatly
|
| linking charts to one database | 31 Jul 2008 23:40 GMT | - |
I want the same chart from the same database to be linked to two different worksheets so that any changes made will transfer to both charts.
|
| Link from Chart File to Data File / Format Problem | 31 Jul 2008 22:15 GMT | - |
I have two Excel files. One file with the chart and a second file with the data range. I have the data range properly formatted with currency. When I open the file with the chart, the chart has all the numbers from the data file. However, the currency formats do not flow ...
|
| how do I get rid of the dark lighting under surface plot chart? | 31 Jul 2008 17:31 GMT | - |
I have created a 3d surface plot - Chart On the underside of this surface is a dark 3D lighting effect. How do I get rid of this?
|
| how do I get rid of the dark lighting under surface plot chart? | 31 Jul 2008 17:30 GMT | - |
I have created a 3d surface plot - Chart On the underside of this surface is a dark 3D lighting effect. How do I get rid of this?
|
| Problem Printing Excel Charts | 31 Jul 2008 15:55 GMT | - |
I’m using Office 2007 with SP1. I’m having problems printing charts that are inserted into their own sheet when they are fit and printed to 11x17. The printed chart will cut off about 3 inches at the bottom. If I resize the chart about 3 inches shorter it prints, but I want it ...
|