3D Chart Resize
I created a 3D chart and I would like to make it longer (on the horizontal
axis) without increasing all the white space. In other words, I want to make
the space that contains the columns longer. I don't want to make the whole
chart box bigger, just the data series area. Do you know how I could do that?
Thanks in Advance.
3D charts have less flexibility in resizing the Plot Area.
With the chart selected and the Chart toolbar displayed open the Object
dropdown on the Chart toolbar, the first tool, and choose Plot Area, then use
the resizing handles.
You may find it use...How do I change chart defaults so new charts have them automatical
I wish to have Excel automatically load chart defaults that I specify into
any chart I create, so that I don't always have to change the same things
over and over again.
Create a chart(s) which have the desired options.
With the chart selected choose Chart, Chart Type, Custom Types, User
"Ron Antweiler" wrote:
> I wish to have Excel automatically load chart defaults that I specify into
> any chart I create, so that I don't always have to change the same things
> over and over again.
...Missing Charts in Monthly Reports
For the past few weeks, I've noticed that every time I try
to load up a monthly report, the Monthly Report Progress
bar seems to work (although it seems to hang
on "estimating next year's taxes" for quite a while). But
after the bar has done its thing, the actual monthly
report is totally blank - no charts, no lists, no
anything. The correct title is listed at the top (for
example, "Report for September, 2003"), but there isn't
any data beneath it. I'm using Money 2003. I'm not sure,
but the problem may have started after I downloaded a
rec...Excel "Text to column"
I need to export data from a database I am working with, to an exce
file, to make it easier for me to edit certain changes.
For one part of this, all of the data appears in one cell (seperated b
I use the "text to columns" function, to change the data into multipl
columns to make it much easier to read, work with, and edit.
My problem, is changing it back to the one cell, so that I may the
import it back to my database.
Part of my excel sheet looks like this after the text to column:
where the large blank space is two empty cells. I know the correct ...Doughnut Chart & Conditional Formats
I want to great a doughnut chart with 12 equally size 'segments' (Jan
For each month the value will be either blank (for a future month) or
Red, Amber or Green.
I then want each segment to be coloured based on it's RAG status and
filled with a label that says R, A or G.
Is this possible?!?!
P.S. I have seen from some of the other posts on here that it is
possible to conditionally format a bar chart, try as I might however I
have been unable to make it work for a doughnut chart!
Which version of Excel are you using?
&g...Unstable charts size
I am using in excel 2007 some charts developed in 2003 version; they are
positioned in a single chart sheet (used..location ..option); at the first
opening in 2007 I observed they were all contracted in size, and some of them
missing (or too small to be found even at 400% zoom); after re-arranging,
tried to fix their dimensions using "lock aspect" (looked around for another
option but didn't find); finally, charts seems to be on their own, as their
size is shrinking even while working in another sheet!
Maybe there is someone to know a hidden option/command/trick in order ...Grouping on a chart
I thought this was going to be a simple task but it has escalated
beyond the boundries of my mathmatical knowledge. Which isn't saying
I am trying to make a chart based on these items.
vehicle - (this is just an ID Number)
puDate - (this is the date the vehicle was received)
rDate - (this is the date the vehicle was returned)
duration - (this is the amount of time the vehicle was out)
I am getting this data from an access query so here is more data that
I can retreive if it helps in any way.
cStart - (this is the date where I want the chart to start. ex. Value
Y axis scale Min)
...Combination charts #7
Question, I want to make a stacked-column chart with horizontal lines and I
can't seem to do it no matter what I do like even change the series. PLease
Is the stacked column the 3d variety? If so you can not create
combination charts with the 3d types.
> Question, I want to make a stacked-column chart with horizontal lines and I
> can't seem to do it no matter what I do like even change the series. PLease
It's not the 3D type. It's just a stacked column with negative f...Pivot Chart
I created a Pivot chart from Pivot table, however, as the user changes the
options (from pivot fields), then the chart type changes back to default one
(I want the line-column 2 axes one). I figured I could go to VBA properties
to default the chart type by choosing the chart code, however under that
list, there is no chart code for that combination chart (line chart + column
chart with 2 axes). How can I do this?
Can someone help... as I am not good at VBA? Thanks!
If you turn on the macro recorder as you apply the custom chart type,
you'll get code similar to the following:
...Labeling each data point in scatter chart
Is there some way to create a scatter chart automatically with each of the
points labelled from the following data? I have over 100 data points each
with a unique label and doing each series x value, y value and name
individually takes a lot of time. I could transpose the data if it helps.
label x y
aaa 150 0.001
bbb 200 0.0005
ccc 35 0.03
ddd 15 0.1
Use one of these free utilities. They integrate very smoothly into Excel.
Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files...resize chart or axis titles in Excel
In the current version of Excel I can't seem to be to resize a chart or axis
title using the mouse, nor the properties - you don't get the arrows when you
hover over the handles. Can you please advise how to do this now - you
could do it in earlier versions of Excel.
You actually couldn't do this in earlier versions of Excel; we've been
clamoring for this ability for a long while. These text elements only mimic
text boxes, but they are not resizable. If you can't live with the
inflexible sizing of these elements, you could replace them with regular
text boxes, ...Template Wizard with data tracking
Operating System: Mac OS X 10.6 (Snow Leopard)
I set up invoicing for a small business which uses an add-in - the form template with data tracking on Windows. This allows us to automatically produce a summary file for accounts receivable tracking when the Excel file is saved. How do I set up something similar on the Mac? <br><br>Thanks for any help!
Notionally, your Windows solution should work on the Mac.
So your first step is to copy it all to the Mac.
Now: What happens next depends on how you built the form.
Display the "Forms" toolbar in...Customize Legends in a Chart
I am not having any luck getting my legend customized. The basic problem is
that my source for the chart is a peice from my main table. The field name
is "Past Due", with a Data Type of Yes/No. This does not translate well to a
chart legend. The chart itself works very well but the legend shows the
primary color and then a label of either 0 or negative 1.
I setup my own legend using the draw tool bar with some text boxs and
colored squares. That works well until the color associated with either yes
past due or no not past due changes. The color changes when all entries ...to turn a chart around
I`ve a short question.
Is it possible to turn a chart (90degres) around?
I need it for a profile analysis?
How about this
Select the chart
paste that picture in another spot (or move the chart to a different spot and
put the picture where you want it)
And then rotate that picture.
> Hello together.
> I`ve a short question.
> Is it possible to turn a chart (90degres) around?
> I need it for a profile analysis?
...Only allowing incremented Data
I have a database that i use to maintain information about given parts within
different Lot numbers. For example, one Lot of parts will be issued that has
10 individual part numbers within that given Lot. I would like the ability to
require that the next part number entered is the next number in that series.
To be more clear:
Say I have issued a Lot of parts (1-10) and that given Lot is the 3rd Lot in
a set of Lots:
When users are inputing the information about these parts, i do not want
them to be able to enter the info about Lot3Part3 without firs...Getting Trend Line Info from Chart
I am creating a manpower report and updating learning curve charts for a
decision making tool through VBA. The issue I am having is the trend line
(Power) in the charts gives me the output I need but I cannot figure out how
to pull the values I want into the spreadsheet. I have tried a couple of
functions but have come up empty handed. The RSQ function is not multilinear.
Does anyone know the formula for a power trend line? For example out of 100
samples I get the following info:
y = 1.5326x0.0657
R2 = 0.5744
Thank you in advance for any asssistance.
Message posted via Offi...Pnting Multiple Charts on Same Page
I am looking to print multiple charts located on the same worksheet to a PDF
file. I would like the output to look like the print output from the chart
window vs. the view of multiple charts on a sheet. Please let me know if you
have any tips. Thak you
Select each chart in turn, go to Chart menu > Location, and choose As New
Sheet. Select all of these chart sheets, then do your printing.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"GKilloran" <GKilloran@discussions.microsoft.com> wrote in message
news:...Can't set alignment in Pivot Chart
I have a pivot chart with 2 level category labels on the
x axis. It looks a bit like this:
1/4 1/6 | 1/4 1/6 | 1/4 1/6 | 1/4 1/6 |
Company A | Company B | Company C | Company D |
I can change the dates (1/4, 1/6) to display vertically,
but not the company names(Company A, Company B).
Is there a trick to this? I added a third level, the
year. But I still could only change the top level.
Thanks for any help!
I am currently creating Excel charts manually. I have been extracting
data from a data warehouse (flat file), using a pivot table I slice the
data and cut and paste it into the appropriate Excel chart. I have
almost 100 charts at this time. This process is extremely time
consuming, not to mention dangerous.
I am trying to decide how I should implement chart automation.
Ultimately I would like to feed a flat file into a database (I have
Access available) and have all the charts automatically update. All
charts are distributed to management, so I would also like to have the
ability to uploa...Line chart or scatter chart??
I have many sets of data for which the x-values run up from approx 60 to 100,
and back down to 60ish. Each set of data consists of 200 points. I can
happily display each set individually on a scatter chart, with the categories
from, 60 (at point i=1)to 100 (i=100) to 60 (i=200). My probably occurs when
I want to display two sets of data on the same graph. For each set, the
x-values vary, for example another set could run from 65 to 95 then back to
65, but it still contains 200 points. Excel will only allow one set of values
on the category axis, so only one data set will be correctly re...Working With Charts
I have created "Cash Withdrawal" as a payee to account
for ATM cash withdrawals from my checking account. I am
able to call up a report about this "payee" in the
Reports Gallery. But I am unable to customize the report
and make it a chart. How can I make a line chart of my
Line Chart is not an option for the Payee Spending report. You can,
however, use the Account transactions report to create a line chart and only
the select the one payee.
"David Lingenfelter" <firstname.lastname@example.org> wrote in message
news:06d401c39d0d...Shadowing of a bar chart
How do I shade a section of a bar in a bar chart?
If you right-click on that segment of the bar, you'll get a list of options.
Choose 'format data series' and you can change the color, click the 'shadow'
box, or add other textures and features.
> How do I shade a section of a bar in a bar chart?
...derivatives of data
I have a bunch of data points that resemble a logarithmic
curve, but aren't exactly.
I'm trying to find a way to get the 1st and 2nd derivative
of the data, even though it doesn't have a good y=___ form
Have you tried simply using slopes? Put the X values in
Column A and the Y values in Column B. Sort these by
Cloumn A. For approximations to the first derivatives,
Then to approximate the second derivatives, assign:
If any two points share the same X value, you may have to
adjust this to avoi...External Data Connections Error
I have an access database saved to a server with several excel spreadsheets
as linked tables through the database. I then have excel spreadsheets with
external data connections to the access linked tables. I created all of the
files so I have no issues opening or refreshing any of the data connections.
However, others that have access to and use the database, server, and
worksheets receives a prompt asking them to login as the admin with a
password. I never set up a password, so I have no clue what they should
enter. When they cancel out of the prompt, the connections are un...Charting timed events throughout a month
I thought I had a simple task to perform for work. Then, I trie
charting it in Excel and have not had any luck.
I need to take some simple data and for each day of the month, I nee
to chart some usage times (24 hour clock). What we want to identify i
where simultaneous instances occured.
Date Start Time Stop Time
11/1/03 09:03 09:53
11/1/03 10:21 10:25
11/1/03 10:23 10:54
11/1/03 14:56 15:31
11/1/03 15:17 15:49
I've no clue how to set this up. I thought I mig...