|
|
graphs by
brian via OfficeKB.com
hi
Would like pointing in right direction
i have spreadsheet with data as follow
column A (list of name)
column B, C , D etc (labelled 1, 2 3 etc)
data...
|
|
1 |
107 |
|
|
How do I create a CORRECT histogram? by
Brian Chisholm
I'm trying to create a histogram for 50 values. I've put in the upper bounds
as my bin values, as was posted by another user. However, the frequency
output...
|
|
1 |
253 |
|
|
Scatter plot - macro OK - VB 6 not OK by
Brian Elliott
If I have 2 rows of data, say, A1 to C1 and A2 to C2 and record a macro :-
Charts Add
ActiveChart.ChartType = xlXYScatter
ActiveChart.SetSourceData Source...
|
|
1 |
114 |
|
|
|
|
1 |
137 |
|
|
Chart Sizing Handles by
Brian Gardner
When a chart is created it usually has a series of boxes that encompass the
data contained in the chart much like it does with a SUM function. If these
boxes...
|
|
3 |
225 |
|
|
|
|
1 |
115 |
|
|
|
|
2 |
100 |
|
|
Label formatting by
Brian Reilly, MS MVP
Hi folks,
This is how to create a custom format for use in chart labels.
I have data already in the worksheet with decimal values e.g.
".25678%"
I want this...
|
|
8 |
195 |
|
|
Chart PageSetup Size Speed VBA by
Brian Reilly, MVP
Hi folks,
I am completing an Excel VBA project that creates custom chart sizes
from a Library of existing pre-formatted charts by using the Move or
Copy Sheet...
|
|
4 |
155 |
|
|
PowerPoint-tags in Excel by
Brian Reilly, MVP
Hi folks who know the use of tags in PowerPoint,
I have presentations in PowerPoint using MSGraph 2003 and here's what
I want to do via VBA.
This part I...
|
|
4 |
120 |
|
|
100 % bars with a constandt average by
Brian Reilly, MVP
Hi fellow MVP's,
I am automating (VBA) bar charts in XL and have most of it under
control but have one outstanding issue that It would appreciate
comments on....
|
|
1 |
158 |
|
|
Multiple charts on single chart sheet by
Brian Reilly, MVP
I would like to place two charts on the same chart sheet via VBA which
I can do.
The problem is in resizing the second chart.
The logic I am using is...
|
|
3 |
240 |
|
|
XL Axis label formatting issue by
Brian Reilly, MVP
Hi folks, I know that has been asked a million gazillion time but
can't chase down a good solution, or missed it for an XL solution.
Forget MS Grump.
The...
|
|
5 |
227 |
|
|
XL chart sheets Custom size for PPT by
Brian Reilly, MVP
Hi folks,
I have an app that uses XL chart sheets rather than charts on a
worksheet. I prefer that, but am not married to that. But kinda like
the approach of...
|
|
6 |
115 |
|
|
Conditional Formatting for Charts by
Brian Reilly, MVP
Hi all,
I understand the concept of conditional formatting in spreadsheets in
XL 2003 just fine.
Can the same functionality be extened to XL Charts? I am...
|
|
3 |
113 |
|
|
|
|
1 |
104 |
|
|
Can't create dynamic charts by
Brian Sells
OK, here is my problem....I am trying to create a dynamic x-bar chart and a
dynamic moving range chart. I am using the StatPlus add-in and can't get this
to...
|
|
7 |
607 |
|
|
|
|
1 |
257 |
|
|
EXCEL Chart Expertise by
brian sloboda
Is there anyone in this group that can offer EXCEL expertise in an offline
environment? I need some assistance in doing a chart. Thanks Brian
|
|
0 |
77 |
|
|
EXCEL Chart Expertise by
brian sloboda
" Is there anyone in this group that can offer EXCEL expertise in an
offline
environment? I need some assistance in doing a chart. Thanks Brian
|
|
0 |
107 |