|
|
|
Re: Naming a chart object
Mon, 22 Sep 2008 04:51:00 -0700
Jon,
When I use the following code:
ActiveChart.Parent.Name = "z"
the VB editor automatically adds the autosave code:
Application.Goto Reference:="PERSONAL.XLS!renamechart"
Windows("PERSONAL.XLS").Activate
ActiveWindow.WindowState = xlNormal
How can I get it not to save each time I rena ...
|
Stacked Column Chart with 2 different axis values
Sun, 21 Sep 2008 18:52:01 -0700
I need to create a stacked bar chart with two different axis. I need to
show, for 2007 and 2008, by quarter (Q1, Q2, Q3 and Q4), the value of options
given to team members and the number of team members receiveing them. (one
axix for the $$ amount and one for the count of team members) Here is my
data.
...
|
Excel (2007) won't do a particular X-Y (Point) graph for me..
Sun, 21 Sep 2008 06:38:01 -0700
Hi,
Well, Excel _does_ X-Y graphs, but not this one.
I have, in the columns A, B, G, and E from row 7 to 5175, sequential time,
data, and data (and dummy data) , respectively.
When I make an X-Y plot using the time column for the X-axis, it plots as
expected.
But when I plot column B versus column D, I get ...
|
Trying to add resource allocation data to a gantt chart built in E
Sun, 21 Sep 2008 06:19:01 -0700
Hello,
I'm using Excel 2003. I've been asked to create a one-page report that shows
major projects and work assignments, and their durations over a period of
time so we can see where they overlap and competing for resources. So I
created a gantt chart in Excel using the stacked horizontal bar chart feature ...
|
Pie Chart- 30 equal 12 degree slices?
Sun, 21 Sep 2008 02:22:19 -0700
Can someone tell me how to make Excel draw a pie chart with 30 equal
segments?
What I'm trying to do is layout 30 tic marks every 12 degrees around the
perimiter of a circle and this seems like it might work.
Thanks!
...
|
change max scale in chart
Sat, 20 Sep 2008 20:18:17 GMT
Hi
I am tring to get a macro to change the maximum scale value in a chart, based
on a cell in the data sheet. In this case G5 in data "sheet1". In cell G5 ,
I have the max formulaI have named the chart "test". I have pasted the code
in a module, and if, with help, it works, will paste the second code in "Th ...
|
Candlestick chart scrolling and zooming
Sat, 20 Sep 2008 10:23:17 -0700
Hi, Chris, I've been trying to do the same. Would you please send me an Excel template for scrolling and zooming Candlestick chart? My email address is shu001@yahoo.com. Thank you very much.
Shenghui ...
|
|
|
Annotating line graphs using arrows
Sat, 20 Sep 2008 08:42:40 -0700 (PDT)
I am creating a line chart in Excel, and want to annotate various
movements in the line. It is a share price graph, with price against
date (and volumes on a secondary axis), and I want to explain the
significant peaks, troughs, movements etc.
Ultimately I want arrows to point to the line, with the arrows
se ...
|
I need to chart some data points!
Fri, 19 Sep 2008 14:43:01 -0700
I am trying to chart two columns from a .csv file. In the Chart Wizard.
When it gets to the Data Range, the field is blank. So I high lite the two
columns again, and try to hit next button. Microsoft excel says, "A formula
in this worksheet contains one or more invalid references. Verify that
formulas co ...
|
Auto Data Source Adding
Fri, 19 Sep 2008 11:45:01 -0700
I am developing a series of charts that will have data added to them on a
monthly basis. Specifically, I would like the data source to add one column
of data every month. Currently, all I could come up with was highlighting a
bunch of empty fields and letting the data catch-up. The problem with that
is: i ...
|
|
|
