Pie charts - 0 values
Thu, 18 Mar 2010 19:53:01 -0700
Hi,
I have selected data labels for my pie charts containing value and
percentage. However, there are 0 values in the chart and I do not want to
show them. I have tried 0%;;;; but it only hide those values in percentage
while the value data labels are still visible. And when i use 0;;;; it hides
the value ...
|
Incorporating Text Box in Excel Chart
Thu, 18 Mar 2010 17:21:01 -0700
I have a chart that has a text box at the top. Every time I change or move
the chart the text box ends up out of place. Is there any way to
"incorporate" text box with the chart so that it keeps its relative position
as the chart changes or moves?
Thanks in advance
Al ...
|
ReAim chart data range
Thu, 18 Mar 2010 14:45:02 -0700
instead of the tedious retyping the cell references to change the data range
for a chart, is there a way to do it with sliders? If so, how?
thanks,
Dan ...
|
Can not get Excel macros to format/save charts--help??? :(((((
Thu, 18 Mar 2010 14:04:01 -0700
Help??:((( I've spent the last 5 days searching on this forum for problems
similar to what I have but no luck! I am trying to use Excel macro to create
a simple bar chart and to format the chart type/etc...but the macro keeps
erroring when I try to run it.
The debug points to "
'
Set ActiveChart = Activ ...
|
Can not get Excel macros to save chart format -lost in space!
Thu, 18 Mar 2010 12:07:01 -0700
Help??? I've been searching this forum for 5 days trying to find a problem
similar to what I am having without any luck.
I have been trying to use Excel macro to record the creation, formating and
saving of a simple bar chart against my Excel data range but the macros do
not run for the chart. I am able to ...
|
Need a template for a chart in APA format
Thu, 18 Mar 2010 09:53:01 -0700
I need to do an assignment for Psych. on Stress and Disease, I need to do a
chart and am looking for a template. ...
|
Radar charts - Angle of category label
Thu, 18 Mar 2010 08:32:00 -0700 (PDT)
Is there a way to set the 'custom angle' of category labels one-by-
one?
I want to arrange them radially.
I have a solution using dummy data but the offset from the centre
point of the radar is excessive.
Any ideas?
Steve ...
|
|
|
Color box unavailable on Patterns tab in "format data series"
Thu, 18 Mar 2010 05:52:08 -0700
I have a user who is working with some charts and can not edit the color box
(is grayed out) on the patterns tab in â??format data seriesâ?. We feel it is
a user setting or something because a different user can pull in the same
spreadsheet and edit the color of a graph bar just fineâ?¦ Has anyone
encou ...
|
Why do my pie charts have labels which say "add text"?
Wed, 17 Mar 2010 13:40:02 -0700
Using Excel 2007 and my template comes up with this add text label for
multiple labels on the pie chart. Even when I save a new template it still
happens. Why? ...
|
How do I keep formatting when creating a chart from a pivot?
Wed, 17 Mar 2010 12:23:02 -0700
I have a data source that I use to create various pivots and the I use thos
pivots to create graphs. I replace the detail for the pivots each month and
refreash each pivot which updates the graphs. The problem is the column and
data values lose their formatting when I refreash the pivots. Is there a way
to ...
|
