|
1 |
Snapping a chart area with Alt |
|
2 |
Snapping a drawing area with Alt (2007) |
|
3 |
Using F4 or Ctrl-Y to repeat |
|
4 |
Transferring a color palette to another folder (2003) |
|
5 |
Using Excel sample templates |
|
6 |
Using Excel sample templates folder.xlt[x] automatically |
|
7 |
Using Excel format templates |
|
8 |
Making text format default setting in a chart area |
|
9 |
Switching off automatic scaling (2003) |
|
10 |
Calculating column width |
|
11 |
Reversing the Y-sequence in a chart |
|
12 |
Realizing the X-axis line using columns or bars |
|
13 |
Realizing the (X-axis) line using 2 points with a connecting line |
|
14 |
Creating the (X-axis) line using several points and realizing a variable width with Y-offset |
|
15 |
Realizing labels as a point |
|
16 |
Linking a label to cells |
|
17 |
Positioning sums as transparent columns or bars on a secondary axis |
|
18 |
Realizing an X-shift with AREA.MOVE |
|
19 |
Realizing an X-shift with name and AREA.MOVE |
|
20 |
Realizing an X-scaling with name and AREA.MOVE |
|
21 |
Realizing an X-shift with several data points and gap width 0 |
|
22 |
Realizing an X-scaling with several data points and gap width |
|
23 |
Realizing variable widths with several data points and gap width 0 |
|
24 |
Realizing a variable gap width with column gap width=0 and gaps as points with white connecting lines |
|
25 |
Realizing an X-shift with time axis |
|
26 |
Realizing an X-scaling with time axis |
|
27 |
Realizing an X-shift with an area chart and time axis |
|
28 |
Realizing an X-scaling with an area chart and time axis |
|
29 |
Realizing Y-scaling with a fixed axis scale and scaling factor |
|
30 |
Realizing a Y-shift for columns and bars with a place holder data series stacked beneath it |
|
31 |
Realizing negative values using a place holder with an absolute value and reducing the place holder by the absolute value |
|
32 |
Switching the data series format by using several data series, one per format |
|
33 |
Hiding point-data points with #NV |
|
34 |
Positioning point-data points to be hidden outside the chart |
|
35 |
Adding data series with Copy Cells and inserting into the chart |
|
36 |
Adding data series with Copy Cells and inserting into the chart with Paste Special |
|
37 |
Adding data series with Drag and Drop |
|
38 |
Realizing a line as a scatter chart with connecting lines |
|
39 |
Positioning graphs in a chart as a scatter chart with a pixel image |
|
40 |
Positioning graphs in a chart as a scatter chart with a vector image |
|
41 |
Rotating graphs in a chart in which a separate graph is inserted on one data point per rotation angle |
|
42 |
Realizing arrow of varying length and position as a scatter chart with integrated arrow points |
|
43 |
Drawing forms as an outline using scatter charts |
|
44 |
Realizing columns and bars finely X-movable as dots with thick connecting lines |
|
45 |
Realizing columns and bars finely X-movable as dots with numerous connecting lines |
|
46 |
Realizing gaps between columns and bars with white lines |
|
47 |
Hiding values in a chart by linking them to a cell range which is hidden using a formula |
|
48 |
Hiding values with a number format |
|
49 |
Labeling columns and bars off-center with a separate point grid |
|
50 |
Placing message, title, and footnote in a cell range behind a transparent chart |
|
51 |
Avoiding a break in a chart with a wider chart area and scaled data series |
|
52 |
Avoiding a break in a chart with a wider chart area and a drawing area snapped to the original size |
|
53 |
Making additional axis groups available by stacking several transparent charts |
|
54 |
Inserting dots in bar charts with reversed X and Y coordinates |
|
55 |
Realizing a bar chart as columns using a rotated camera |
|
56 |
Realizing two colored columns and bars with the "Invert if negative" trick |
|
57 |
Avoiding a drop line in a line chart with #NV coordinates |
|
58 |
Realizing varied column widths with an area chart and time axis |
|
59 |
Realizing a broken line from a data series with a third empty point in an unrelated range |
|
60 |
Realizing a broken line from a data series with a third empty point in a related range |
|
61 |
Realizing columns and bars with an axis opening with a Y-shift of all data series in the positive range |
|
62 |
Realizing time-lapse animation with individual frames and OFFSET |
|
63 |
Realizing time-lapse animation with frames inserted into animated gif |
|
64 |
Display bubbles with the scatter chart type in which a data series is used for each diameter |
|
65 |
Formatting bubbles with a white border to see overlaps better |
|
66 |
Moving individual data series in X-direction by stacking and moving other charts |
|
67 |
Shifting data series in the X-direction by inserting graphs with a transparent area |
|
68 |
Removing duplicates with COUNTIF and VLOOKUP |
|
69 |
Removing duplicates with substring decomposition, RANK and VLOOKUP |
|
70 |
Realizing ranking with RANK and VLOOKUP |
|
71 |
Unifying texts through removal to central area |
|
72 |
Translating texts by removal to central area with HLOOKUP |
|
73 |
Realizing bars in tables with REPT and symbol characters |
|
74 |
Controlling a number format in substrings through external input with TEXT |
|
75 |
Realizing variable graphs in tables with camera and names using OFFSET |
