Format Chart Area
In Office 2003 (v11.0) the "Format Chart Area" window has the "shadow" check
box, but is missing the "Round corners" check box. Are there any suggestions
for restoring this check box, short of reinstalling.
-- Thank you
Best Regards John
If this helps, please click the Yes button
"John Smith" wrote:
> In Office 2003 (v11.0) the "Format Chart Area" window has the "shadow" check
> box, but is missing the "Round corners" check box. Are there any suggestions
> for restoring this c...Pivot Chart
I am studying for a test and created a pivot chart successfully. The
instructions then say to select the chart
and go to 3dView. My 3d View is greyed out.
Where did I go wrong?
First, change the chart to a 3-D sub-type:
Select the chart
Choose Chart>Chart type
From the sub-types, select a 3-D type
Then, the 3-D View command will be available on the menu.
> I am studying for a test and created a pivot chart successfully. The
> instructions then say to select the chart
> and go to 3dView. My 3d View is greyed out.
> Where di...Removing wire frame in 3D surface chart.
I'm am experiencing difficulty to view 3D surface chart as
the number of data points are increased due to the wire
frames in the chart.
Is there any way to remove wire frame in a 3D chart?
To get rid of the frame you need to set the border for each of the
legend entries to none.
The quickest way to do this is to click the legend, then click the
legend marker for the first entry. Double click and set the border to none.
After the dialog is closed use the left arrow key to move to the next
entry. Press F4 to apply changes to the series. repeat for all entries.
C...Linked Charts Lose Formatting
I'm creating a "dashboard" for my company, and as part of this, am linking
various information (charts, tables, documents) into one Excel file, and I'm
then saving the file as a web page for others to browse.
Everything seems to be working, but some of the charts I've copied from
another Excel file are losing their numeric formatting. For example, the
horizontal axis is formatted as dates in the original file, but in the linked
file, they show up as the date serial number (i.e., 39325, 39326, etc.).
Also, the numbers in the data table for the chart are no long...Add source data to an existing chart?
I am building a chart to display, by date, data in columns G
(breakfast), D (lunch), and J (dinner).
I can get the chart with dates along one axis and column G along the
other, but how do I add the data from D and J to create a stacked bar,
to show for each day how each of the three columns compare and give a
daily total for all three meals? :confused:
THANKS TO EVERYONE FOR YOUR HELP! :)
navychef's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29457
View this threa...plots sent to to a chart tab do not show plot & I loss the plot
I have a spreadsheet that has a chart tab with a plot of data from another
part of the spreadsheet. Now, however, the chart is empty and when I try to
send any plot to a chart tab the plot is lost and the chart tab is empty.
This is happening now in all my spreadsheets the plot can be created within a
spreadsheet but as soon as I move it to a tab the plot is lost and the chart
tab has nothing in it. !!!????!!!!
...Combination charts #8
I am new to Excel 2007. I cannot find how to plot a combination chart -
stacked area with a line superimposed but not stacked. Values of line and
total stacked area will be of the same order of magnitude
I don't think you can do it in 007. Charts like this that I prepared
in 003 and brought into 007 went bonkers.
Even stacked column charts have problems with the non-stacked line.
On Feb 12, 8:52 am, Debbie424242
> I am new to Excel 2007. I cannot find how to plot a combination chart -
> stacked area with a l...Pivot Chart update
I'm using Excel 2007. I created a simple 2 column pivot table and a pivot
chart based on the table. When I change the filtering on the table the chart
doesn't update to the new values like it is supposed to. Is there a setting
somewhere that needs to be turned on or what?????
Hi Sharon I have a Pivot Chart in EXCEL 2007 on the screen in front of me.
There isn’t a setting that needs to be turned on.
In my PivotTable Field List I have two items selected:-
Revenue Last Year
I have another field:-
- turned off at the moment.
I drag REGIO...Copying charts
I'm using office 2000 SP3, win 2000.
I routinely paste excel charts into word as enhanced metafiles and set
the line thicknesses and font sizes in excel to produce similar
looking charts. I have just installed SP3 and now I find that when the
charts are pasted into word, the font and line thickness now appear
much smaller than they did with SP2. Do you know why it has done this
and is there a solution?
...position of chart on page moves when outline expands
I have two charts I have made to the right of a budget table. The top
chart is positioned near the top of the page, the second, a smaller
summary chart is just under the first one.
Problem is, the Budget table is an expandable outline that can expand by
dozens of rows. When in expanded mode, the second chart moves way down
off the visible page and is only viewable by scrolling, unless I
collapse the outline again.
The first chart is anchored at the top where little expansion takes
place, thus little movement.
Is there any way I can prevent this second chart from moving down when ...Need an Idea on Arranging Data for a Chart
I have an Access Database that has thousands of records in it. Each record
has the following fields (simplified): Date, Site, Seconds
I have a workbook that wueries the database, and brings in data into a table
for each site that has the Date and Seconds on each line of the table.
I would like to graph the data, based on groupings that the user will
choose, so maybe they would like to each data point on the line be the
average for a week, and the line would show 10 weeks, etc.
What I am struggling with is how to get from the frist table, to one that is
grouped by day, or week, or mont...custom color palette for every new workbook
I have been changing the color palette for each new workbook. Is it
possible to have Excel start out all new workbooks with my own color
On 9 Jul 2004 16:46:34 -0700, firstname.lastname@example.org (Vinod) wrote:
>I have been changing the color palette for each new workbook. Is it
>possible to have Excel start out all new workbooks with my own color
1/ Create a workbook with the palette that you want.
2/ Save that as a file named Book.xlt (Save As type "Template
(*.xlt)") in your xlStart folder, the location of which will vary
depending on your version. (J...Excel charts will not go back to Landscape when selected
When I am on a chart sheet and change orientation from landscape to portrait,
I cannot recover the landscape orientation. I've tried creating new charts,
which originate in Landscape...same trouble...once the orientation is in
Portrait, the Landscape orientation will not recover. Any ideas?
Please, please consider buying GM vehicles; world class quality...really!
Recovery: Changed default printer away from a Ricoh product. Why would the
print driver influence ability to change View Orientation? I was not
attempting to print anything.
Please, please consider buyi...Create chart from List Box
How do I use a List Box, with the months in it, allowing
the user to click on a month and pull up that particular
chart? Do I have to create several charts and use the
list box as a hyperlink or can I have the chart create
Jon Peltier has instructions on his web site that may help you:
> How do I use a List Box, with the months in it, allowing
> the user to click on a month and pull up that particular
> chart? Do I have to create several charts and use the
> list b...how to creat a chart with t diffrrent scales
hi can any one help me in creating a chart with 2 diff. y axis scales
like 0 to 1000 and 0 to 0.001 but x axis being the same or vice versa
You will need 3 columns of data.
Column A contains x axis labels
Column B contains data with values in the range 0 to 1000
Column C contains data with values in the range 0 to 0.0001
Select all the data and use the chart wizard to create a line chart.
Select the 2nd series, one with the values 0 to 0.0001, press CTRL+1 to
bring up the format dialog. On the Axis tab choose Secondary axis.
If you want a chart type of column then you will ne...no more new fonts may be applied in this workbook when changing fo
I get the error "no more new fonts may be applied in this workbook" when
changing font (not adding a Graph).
Any idea how to fix it.
I tried that but did not help.
"מיכאל (מיקי) אבידן" wrote:
> Check this out:
> "Dan" wrote:
> > I get the error "no more new fonts may be applied in this workbook" when
> > changing font (not adding a Graph).
> > Any idea how ...Line chart zero values
I am trying to do a automated line chart that updates as
users input over the next 12 weeks... the chart is
consisting of 12 weeks on the x axis and % on the y.
The problem im having is the values in the table that the
chart is picking up from are formulas... but if the
formula result is zero or ""(blank) I want the line chart
to ignore it... rather than plot zero values making the
line drop when a nil value or blank... for rest of the
whole 12 weeks...?
week 1 = 10%
week 2 = 11%
week 3 =
I want the line to stop at week 2...? but because to work
out the % is a formula...Scatter chart with columns instead of points
I need to create a chart showing the number of students who received each
numerical grade on test. The spacing between grades is not equidistant (ex:
65, 70, 90, etc.) and I need to show the true spacing on the x-axis. So I
chose a scatter chart because the other charts make the points of equal
distance on the x-axis. The trouble is I need to represent the data as
columns so if two students scored a 65 and eight scored a 90, the 90 column
would much higher. Is there a way to add vertical columns to a scatter chart?
Put your grades in a column, and include the grades which had none. ...Charts.add stopped working
I programmed an application which adds a chart to a sheet with a simple:
But now excel gives me a Runtime Error 1004 while creating the chart.
However, if I set up a chart manually and record the macro it does the
exact same thing. if I run the macro afterwards, I still get the 1004!
Any suggestions are welcome
Thanks in advance
What do the cells A1:B3 contain?
> Hi all
> I programmed an application which adds a chart to a sheet with a simple:
&...Chart showing rates of increase
I am a trainer and have been given the fictitious scenario described below
to test my Excel skills.
My question is: What is the best way to build a chart to show the RATES OF
INCREASE between Price of Crude Oil and the Cost of Heating Oil for three
different companies. Here is he scenario:
You are asked to put some learning together for a group of litigation
attorneys who will be off site for a trial. They need to learn the easiest
way to turn an excel spreadsheet into a chart and put it into PowerPoint
The spreadsheets are not very complex they say. They are tracking...Changing a bar chart
In a standard bar chart, with say 5 yrs of data, I wish to make the 2006 bar
a stacked bar with the lower part the ytd and the upper part of the bar the
estimated year end. Pls help.
\\ ~ ~ //
( @ @ )
You could enter the data in two rows, then create a stacked column chart
from all the data. For example:
2002 2003 2004 2005 2006
YTD 50 55 60 65 30
Charles Woll wrote:
> In a standard bar chart, with say 5 yrs of data, ...How can force enable macros to be able to open my workbook?
I would like to be able to force employees to enable macros for a certain
workbook or it will not let them open the workbook. And maybe put a password
on it so if i would like to modify the workbook without the macros enabled.
set up the workbook so that the only sheet showing is one with a message
which says "You must enable macros for this workbook to work." in a large
obvious font. Have the workbook password protected and all sheets
In the workbook_Open event, hid that message-sheet & display the sheets
which you'd need to have visible.
So, if the user disab...radar chart
i am trying to do a radar chart of activities of my organization in
comparison to other organizations. as a result, i have stacked filled in
areas, however i am not able to make them transparent so as to see the area
under the one that is on top. There is a tab for "Transparency" under
"Patterns" - "Fill Effects" when I double click on an area i want to make
transparent, but I cannot make it work. The transparency tab remains
unresponsive. Anybody have any advice? Thanks.
1. Buy a Mac (ugh!)
2. Apply some trig to adapt these techniques to a radar chart:
...Publisher or PP for Web Page Chart Illustration?
I need to create some content for web site pages and don't know whether to
use Power Point or Publisher. I need to create flow charts of sorts with
boxes, diagrams, arrows and descriptive content. I need it to be bright,
colorful and visually appealing; may or not be animated.
I have both products in Office '07 but don't know which to use and will have
to learn as I go. I don't need to actually creat the web page...just the
content for the web designer. Thanks!
I don't use Power Point, but it seems to me that using Publisher for layout
makes the most sense. Then sel...Chart problem: values in column A doen't show on x-axis
The data in column A in the table I want to use for a chart contain
numeric values: 2000 - 2001 - 2002 - ...
In the chart these don't show as labels for the x-axis, but as a serie
of data in the chart.
Any way around this without changing all the values in coumn A int
digicat's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1492
View this thread: http://www.excelforum.com/showthread.php?threadid=49945