|
|
|
|
0 |
627 |
|
|
|
|
0 |
587 |
|
|
Lines in graph only if values in fields by
Jon Peltier
Hi Vitor -
Have your user change his formula to
=IF(P6=0,NA(),1-(P9/P10))
The "" is an empty string, which Excel interprets not as a blank, but as
a bit of...
|
|
0 |
515 |
|
|
Pie Chart - Conditional Color by
JAM
Hello.
I am trying to create a pie chart with 10 labels each linked to a cell
of the same value, so the pie pieces are of a uniform size. I would
like to know...
|
December 5th, 2003 05:46 PM
by JAM
|
0 |
155 |
|
|
Organizational chart by
Patricia
I am looking for aprogram to download i am doing a project and I need to make an organizational chart the one I heard of was called "inspiration' it had some...
|
|
0 |
197 |
|
|
|
December 9th, 2003 09:06 AM
by JZJT
|
0 |
69 |
|
|
|
December 6th, 2003 12:40 PM
by paris3
|
0 |
81 |
|
|
|
December 11th, 2003 09:01 AM
by VJ
|
0 |
392 |
|
|
Lines in graph only if values in fields by
Vads
Dear readers,
I've got a challenge for all. Working at a helpdesk, I've got a
question from an user regarding the following situation.
User has a sheet with...
|
December 5th, 2003 03:21 PM
by Vads
|
0 |
251 |
|
|
Pivot Chart Bar Width by
Jon Peltier
Pat -
The bars are based on a percentage of the spacing between categories.
If you have fewer categories, the bars get wider. If you decreased the
bar width...
|
|
0 |
231 |
|
|
Using string data to create charts? by
kat
We just did something similar in my statistics class. In
order to simplify the information, we assigned a numeric
value to each word - this allows you to run...
|
December 1st, 2003 09:18 PM
by kat
|
0 |
238 |
|
|
|
November 19th, 2003 08:12 PM
by Chris
|
0 |
466 |
|
|
Help with Data (Table) below my chart by
Jon Peltier
Sharon -
It's nearly impossible to align the data in the worksheet with the
plotted points, but at least they can be in the same relative positions.
I've...
|
|
0 |
569 |
|
|
Properly formatting Dates on the X axis by
Jon Peltier
Robert -
You can achieve the first objective if you make a Line chart, with a
Time-Scale axis (Chart menu Chart Options Axes tab Category Axis
Time...
|
|
0 |
373 |
|
|
|
|
0 |
893 |
|
|
|
|
0 |
423 |
|
|
Charting Date Ranges by
Jon Peltier
Enig -
Your data should be Campaign Start, and Duration (which is Ad Order
Close minus Campaign Start). Plot this data the way you already have,
but in a...
|
|
0 |
258 |
|
|
Source Data Ranges in Charts by
Tushar Mehta
If the data set for each event is contiguous (i.e., no gaps in between
the start and end cells), you could use the concept in the Excel |
Tutorials | 'Dynamic...
|
|
0 |
725 |
|
|
Excel Charting - Pareto diagrams by
Philip
I'm doing statistical control and have a proces that can
go wrong via 13 different causes. I'd like to plot this
info monthly as a series of disconnected boxes...
|
December 1st, 2003 05:00 PM
by Philip
|
0 |
220 |
|
|
|
|
0 |
605 |