|
Stndard Chart Wizard color selections
I do not like the defaults used by chart wizard in EXCEL. Is there a way of
changing them?...
|
2 |
12/16/2008 2:36:31 PM |
|
|
100% Stacked Column Chart Labels
I've created a chart with several 100% stacked columns, each having multiple
data points in common. I'd like to show what percentage each of the data
points is in relation to its column but the percentage data label is greyed
out. Is there another way to do what I'm trying?
Thanks!...
|
4 |
12/16/2008 8:53:05 AM |
|
|
Scorecards using MS Exel
Hi,
I am looking for some decent walkthroughs on creating scorecards using
Excel. I have seen some samples on the net and they don't focus much on the
details of implementation. Would appreciate if someone can point me to some
detailed walkthroughs on this....
|
4 |
12/15/2008 9:43:41 PM |
|
|
Excel 2007 Funnel/Tornado/Pyramid Charts
Hey,
In excel 2007, how can I create Funnel/Tornado/Pyramid Charts? (based on a
pivot or something), is there a template for it?
I find to hard to believe it doesn't exist... :)
Thanks,
Ron...
|
2 |
12/15/2008 9:12:36 PM |
|
|
20 rows but need to display only 2 at a time in a chart.
Hi friends,
I have a chart with 20 rows and columns. I need to compare 2 rows at a time
in a simple line chart to see thier progress, for example row 1 with row 5 ,
then 4 with 10 and then 1 with 16 etc.
what would be the easiest way to achive this, for now I have to do it by
selecting the rows each time by edit data.
Can I have 2 dropdown menus above the chart with the column names...
|
3 |
12/15/2008 3:34:01 PM |
|
|
plot area inconsistent sizes with VBA
I run a series of charts on a single sheet that look at different but
similar types of data. the x-axis values are always the same. The y-
axis is the same count but different ranges of values. The charts are
set to be the same size and the plots are set to be the same size. On
some of the resulting charts the plot height is slightly smaller and
the plot width is about half even though the ...
|
1 |
12/15/2008 2:30:58 PM |
|
|
binding points in a line chart when having empty cells
Hi,
I need to make a linechart, but I do not have values in every cell in
columns I am using. I would like the values I have to be binded together. Now
they are binded if there are no emty cells between 2 points.
I can not put in values in the empty cells, they have to be empty..
...
|
2 |
12/15/2008 9:02:55 AM |
|
|
Value Axis Adjustment
I created a Gnatt Chart with 8 activities. The times on the values axis are
listed as 3:50 AM, 4:19 AM, 5:16 AM, 6:14 AM, 6:43 AM, 7:12 AM, 7:40 AM, 8:09
AM, 8:38 AM, however since my activities take place between 5:30 AM and 8:15
AM, I wanted to decrease the time that is displayed on the chart
dramatically. For example, I would like to see the time on the values axis
displayed in 5, 1...
|
6 |
12/15/2008 3:22:33 AM |
|
|
Can't get chart from SQL Data
Hello Friends,
Please help to solve this problem:
I run SQL query, received the output, saved them in Excel and tried to plot
a chart but no success.
Actually I only can plot the chart after I re-write all data in equation
type, I can't get chart from original Excel data which contain decimals.
BRs,
A...
|
2 |
12/15/2008 1:43:00 AM |
|
|
Making a Blank Cell
I am displaying monthly data in a simple line chart. When the data in the
assoicated cells (say for april onwards) is completely blank (not data or
equation in the cell) the line on the chart stops at march (this is the
effect i need).
However, the data in the cells is not typed in but calculated from other
cells. With the presence of the formuae the chart automatically assumes that
...
|
3 |
12/14/2008 8:11:01 PM |
|
|
Paste special in VB
HI i'm trying to paste all the chart that exsits in the workbook one sheet ,
the method is working but some times i get "'run time error '1004'" .
Any idea what i'm doing wrong?
Here is the method that do it :
Sub ChangeGraphsToPhotos(Wbk1 As Workbook)
'wsheet = Nothing
Dim wsheet As Worksheet
Dim FileName As String
Dim ch As Chart
i = 1
j = 1
'This code works fine for chart shee...
|
2 |
12/14/2008 8:02:40 PM |
|
|
Funnel Chart (?)
Not sure if I have the right description here.
What I'm trying to show is the range of possible outcome values around a
mean over time. I actually have something working, but there are a
couple small problems with it and I'm wondering how others may have
accomplished this.
Example here:
http://vfdrake.home.comcast.net/~vfdrake/files/excel/funnel_chart.png
This would resemble the ch...
|
3 |
12/14/2008 6:26:12 PM |
|
|
Setting x-axis crosses with VBA
I have a chart that at the moment has a vertical range from -70 to
-92. I'm trying to set the horizontal axis to cross at the minimum
value, in this case -92. Using
With ActiveChart.Axes(xlValue)
.Crosses = xlMinimum
It crosses at -70.
If I use xlMaximum I get the same thing.
Using
.Crosses = xlCustom
.CrossesAt = -92
it crosses at -92. however, I...
|
3 |
12/14/2008 3:55:47 PM |
|
|
Make chart formatting as easy as it was in 2003!
Back in Excel 2003 it was very easy to create and edit charts, which is one
of the most important features for my useage.
Now in 2007, the chart wizard is no longer there, so you are forced to
create a chart, and then adjust the chart to the way you want it. This means
that if you know what you want the title and axis lables are, and if you know
that you want the chart located somewhere...
|
2 |
12/13/2008 8:39:04 PM |
|
|
Horizontal dates
Am I being dull here? I am trying to run weekly dates on the horizontal axis
- say Aug 15th onwards. That is - Aug 15, Aug 22, Aug 29 etc. But I cannot.
I am clicking max, minor units, fixed, automatic, date axis buttons but I am
getting no where except going completely nuts.
I've bought a book. No help at all. Been on Microsoft Help. Nothing.
Lots of what to do but doesn't solv...
|
5 |
12/13/2008 8:27:22 PM |
|
|
Time Scale for Charts
In the 2003 Version of Excel I was able to set time scales with a Min Date
and Max Date - for example: 1/1/2008 - 12/31/2008. I have charts that
measure the Call volumes in our area per month and I am unable to see each
month on the Horizontal Axis.
Thanks, Susie...
|
4 |
12/13/2008 8:19:29 PM |
|
|
Delete Chart Event
Hi All
Is it possible to detect an event when a chart is being deleted in vba?
Thanks a million
Kike...
|
4 |
12/13/2008 11:32:59 AM |
|
|
Time Scales on Horizontal Axis - Excel Charts
I am trying to create a Chart with the Vertical Axis being Calls Received
Horizontal - Months. I am unable to see the Month Names across the
Horizontal Axis as I use to in Excel 2003. How do you adjust the Time Scale
Min & Max to reflect 1/1/2008 and 12/31/2008 so that they show on the Horiz.
Axis?
Thanks
--
Susie...
|
2 |
12/13/2008 11:27:01 AM |
|
|
y axis
I have a chart that auto-formats the values of the intervals of the y axis.
That is fine. However, when I preview the chart, the intervals change and
the chart prints with those changed values. ...
|
2 |
12/12/2008 11:58:16 PM |
|
|
Pie Chart - Dashboards
I am creating a dashboard in excel, If I have 200 baselined milestones in a
project and I have completed 170 of them, how can I create a pie chart to
reflect the percentage complete?...
|
2 |
12/12/2008 11:54:36 PM |
|
|
Labeling points on a line chart
I have a chart that has 5 lines that track the error percent for specific
tables in our data conversion. I have some code that pulls in the date when
it goes out and populates the data series - and I would like for each date to
be the label for each of the data points on the chart.
Is it possible to specify what the labels should be? I can hardcode them
ahead of time or make the labels ...
|
2 |
12/12/2008 11:53:37 PM |
|
|
Charts resize themselves
Hi everyone,
I'll try to be brief.
I am new to Excel 2007 but have used 2003 extensively.
My job requires me to do heavy sales analysis of our products. As such, I
have created a system in Excel VBA (within Excel 2003) that creates a
workbook that consists of several worksheets each of which contains a line
graph that gives a visual representation of a product's sales history.
Th...
|
1 |
12/12/2008 3:51:01 AM |
|
|
Problem with scatter chart
Hi Everyone,
I have a risk register and want to create a scatter chart with the risk
scores.This works fine but here comes the complicated bit. I would like the
background to have three different colour and to represent the three areas of
risk and this should be per number. i.e under axis y 1 and axis x 2 the
colour of the square should be green,under axis 2 and axis 3 the colour of...
|
2 |
12/11/2008 9:46:28 PM |
|
|
Dates in Chart Legends
I'm using dates in the horizontal legend of a column chart. On the data
source, there are only columns for the days we actually worked, i.e. there
are no columns for the dates for Sat, Sun, Holidays, etc. There are no
hidden columns in the sheet.
When I select that area for the horizontal legend and view the chart, all
dates are displayed in the legend, leaving gaps in the chart. I r...
|
5 |
12/11/2008 9:44:08 PM |
|
|
Pie Chart Options
Good Afternoon,
I am attempting to build a Pie Chart in Excel 2003 that has 17 equal size
slices. Each slice needs to represent an option from a cell containing a
drop down with 3 options, yes, no, N/A. Can I get Excel to read the drop
down choice and place the result on the pie slice?
Thanks in advance and have a great day.
...
|
2 |
12/11/2008 9:43:58 PM |