|
|
Pivot Tables by
Mike Archer
Hello. Is there a way for pivot tables to count a field only if it contains a
string of characters?
Example...
|
|
0 |
87 |
|
|
Doing charts in Excel 2000 by
TVG
i am still using the Excel in my Office 200 package. Where can I get udates
to do better charts?
|
|
1 |
117 |
|
|
|
August 9th, 2007 06:56 PM
by Sun
|
4 |
113 |
|
|
negative values in a waterfall chart by
MelissaF
How do you display negative values in a waterfall chart? Everytime I have a
negative value in my data, the bar disappears off the chart.
|
|
1 |
192 |
|
|
|
|
1 |
122 |
|
|
Chart Formatting by
Sandy
Is there an easy way to copy the formatting of an entire chart to another
chart. Or can I change the defaults?
Sandy
|
|
3 |
91 |
|
|
How Do I 'Lock' My Chart? by
archsmooth
I have my Excel data tables in 'list' format. I sort a category in descending
order and make a quick Pareto chart. I sort by another column to make another...
|
|
1 |
98 |
|
|
|
|
1 |
115 |
|
|
hotfix works! by
mk
I complained in a recent posting about very very slow refresh times for Excel
2007 charts, especially for charts whose axis were not default ranges or for...
|
August 10th, 2007 03:10 PM
by mk
|
3 |
124 |
|
|
Lon Lat positions in chart by
Peter
Can anyone help me with the following problem?
I have a number of positions in longitudinal and latitude positions.
At these positions I have data about the...
|
|
1 |
93 |
|
|
E-Mail Causes Formatting Loss by
Rich Kooyer
There is a worksheet that's emailed to several users. The category axis is
formatted to 45-degrees. When opened after email transmission, the axis
reverts...
|
|
1 |
121 |
|
|
Link between values on two axis by
Waacku
Hi,
How can I create a link between values on primary and secondary Y-axis?
These values should not be set manually since there are many sheets and the...
|
|
1 |
120 |
|
|
Control Limit and 3-D chart by
Cardinalgal
I need to add a line to a 3-D column chart. The line would represent the
upper limit. I am using Excel 2003. Any help would be greatly appreciated.
Thanks
|
|
1 |
107 |
|
|
|
|
1 |
107 |
|
|
Slow charting hotfix for Excel 2007 by
h4rrydog
A hotfix is available from Microsoft to remedy the slow charting
problem in Excel 2007.
http://support.microsoft.com/kb/938538/en-us
Unfortunately, you can't...
|
August 11th, 2007 09:23 PM
by Tim
|
1 |
112 |
|
|
macro for work book by
Daniel
How can I write a macro to have it refresh data and text to column/ fixed width
How can I develop this macro not for a sheet but for a work...
|
August 12th, 2007 12:04 AM
by Wigi
|
1 |
92 |
|
|
|
|
1 |
123 |
|
|
|
|
7 |
68 |
|
|
|
|
3 |
192 |
|
|
How large is a chart? by
hmm
I am just asking out of curiosity. How large, in kilobytes, is a chart; say,
a 1000-point x-y scatter? I had a large file whose size was halved when the...
|
|
1 |
67 |