Zero Values on a Pie Chart
Wed, 27 Aug 2008 15:37:01 -0700
Hi Everyone! I am doing a pie chart and I can't seem to get the chart to NOT
display "zero" values on the pie. I have tried everything and still cannot
get it to not display it. I went to 'Tools' then 'Options' then to 'Chart',
where it says "Plot empty cells as:" it is gray and I am not able to select
anyth ...
|
How to save an Excel 2007 Chart as a xml File.
Wed, 27 Aug 2008 15:18:39 -0700
I have a Excel 2007 file. It has a data source and a chart on the same
worksheet. I would like to save this file as a xml file. The problem is not
saving the file as xml but once the xml file is created excel is only
creating a xml file with the data and NOT to chart. Can excel output a chart
as a xml file. ...
|
secondary Y axis
Wed, 27 Aug 2008 11:36:13 -0700
I am trying to write a macro for two y axises. Left side is english (pounds
per cubic foot) and the right is metric. What I have now will allow me to
graph the english with no problem but when I try to add a second y axis I
then don't get any points on the graph. Can anyone help.....Here is the
macro I am ...
|
Changes to Plot area color
Wed, 27 Aug 2008 10:05:03 -0700
I created at template in which the plot area color is bright yellow and
applied to a chart. When I re-opened the file the color turned to magenta.
I've had other problems with cell colors changing on their own also.
Any ideas?
Thanks. ...
|
Charting survey results (Descriptions as value labels)
Wed, 27 Aug 2008 09:10:01 -0700
I conducted a survey allowing people to rank 8 different items as Not
Important, Important, Very Important, or Critical. I want to create a column
chart from this.
To create the column chart, I used a combination of INDEX and MATCH to
assign each answer a numeric value (0 for Not Important, 1 for Important, ...
|
2003 charts don't format to page size in 2007. any suggestions
Wed, 27 Aug 2008 09:07:01 -0700
I have numerous charts created in Excel 2003 that are formatted to print very
legibly on 8-1/2 x 11. Excel 2007 does not seem to make any proportional
adjustments base on paper size, resulting in a long flat chart that is not
legible because the print is too small. Any suggestions on how to modify the
rati ...
|
Charting mixed data
Wed, 27 Aug 2008 06:54:00 -0700
Good morning, hoping you can assist me with figuring out how to chart
different data. Some of the data is total number of patients seen and then
some of it is average waiting time for patient to be seen. The problem I am
encountering is the total number of patients is using numbers while the
average waitin ...
|
|
|
Polynomial equation output
Wed, 27 Aug 2008 06:34:00 -0700
I see the equation used on the chart, but is there an actual place where I
could find the output, in addition to the line on the graph?
Also, can't remember what E is? ...
|
identifying colours of existing elements / series
Wed, 27 Aug 2008 05:45:01 -0700
I have a query in Excel 2007 (and PowerPoint 2007).
Quite often, I want to pick a colour that matches some already existing
colour (perhaps created according to some pre-existing colour scheme). For
instance, this might be to inset text in the same colour as a graph series or
such like. It previous versions ...
|
Text boxes in a chart, disappear
Wed, 27 Aug 2008 05:28:01 -0700
I have created a chart with a text box embedded in it successfully. Whan new
data is added, I need to move the text box further out (left) on the chart,
but after a certain point in the chart, the text box disappears. I have cut
& pasted while the chart is selected but still have the same issue. ...
|
