Double Stack Chart
I'm wondering if there is a way to create double stack within a
month. I want to compare 2008-2009 for each month, Jan, Feb. I was
able to make single stack for 2008 only but want to add another bar
for 2009 for January, then February, etc.
Male Female Male Female
Jan 50 60 35 60
Feb 40 75 40 60
Mar 80 60 30 29
Your help would be much appreciated.
Thanks...Scatter chart, show multipel points
I have done a chatter chart. I would however that it should show if one
co-ordinat has more than one ponit. Exemple: Data is:
Point no x-value y-value
1 3 5
2 3 6
3 3 5
In that case I would like the point 3,5 to show 2 ponits, or saying 2 or
something similar. Is there a good way to achive this?
Assuming your X data is in B2:B4 and your Y data in C2:C4, enter this Array
formula into D2:
Don't type the curly braces, instead hold CTRL+SHIFT while pressing Enter,
...How do I add different cells to have one bar chart?
I have two different worksheets that I need to chart. I only want specific
cells from each sheet to go into a bar chart. I can't seem to make just one
Thanks in advance.
The easiest way is to pull all the data you want for one series into one
continuous range on one worksheet. You can do this by linking from wherever
your source data is. Then create your graph from this range.
"soconfused" <email@example.com> wrote in message
>I have two di...charting date and time data (every minute type)
i have a minute by minute data of certain measurements, which i
wouldlike to go on my x-axis with the y-axis being the measurement
this data goes on for a series of days, with certain breaks of few
minutes in them (mostly due to instrument maintenance)
when i do chart this data, excel ignores the gap in data and thus i get
a erronous display.
also the x-axis doesnt show the date or th time, just 0:00:00
help would be appreciated
Message posted from http://www.ExcelForum.com/
Use a XY Scatter chart and you will get the desired effect. If you
still don't, ...Copying a Chart to ANOTHER WORKBOOK LOCATION not worksheet.
According to Excel Help, I should be able to copy a chart/graph to another
workbook. However, when I try, the Paste option is not highlighted as a
choice. Does anyone have any ideas how I can accomplish this copy/paste
You don't state which version of EXCEL you are using.
I have tried to replicate what you say in EXCEL 2007 but don't see the
You might like to try the following:-
1. Select the graph that you want to copy by clicking in it.
2. Ctrl C (simultaneously).
3. Move to new Workbook.
4. Ctrl V (simultaneously).
This pastes the c...Charting #4
Is there a way to make the default setting for the horizontal axes on
charts set to no line? It is really annoying. When you have 3
different overlayed charts and you have to change this setting it is
very time consuming. Every time I save the document it does not save
this setting. Any ideas?
...Import Charts into Powerpoint
I have created an Excel workbook that contains over 100
charts. Now I want to import these charts into
Powerpoint. What would be the most efficient way to do
I guess you'd be wanting some kind of macro. I have some hints on my web
If you had something different in mind which you couldn't figure out
from these examples, post back.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
> I have created an Excel workbook t..."Chart sizes with window frame" automatically re-checked
I have chart sheets in Excel 2000. I have unchecked "Chart sizes with
window frame" in the Options menu and set zoom on the chart sheets to
100%. My VB program opens the Excel file and updates the cells in the
chart's data series. When run from my Windows 2000 PC, everything is
fine. When run from our Windows 2003 server, everything is fine. When
run as a scheduled task on the Windows 2003 server, the "Chart sizes
with window frame" gets checked and the graphs are zoomed to 139%.
The charts have been pasted into Powerpoint 2000 as links, and this
messes up th...Dynamic Ranges
I need to develop a function which uses a range. The range is dynamic based
upon a Lease Term.
Example: I have a 5 year lease - The range will encompase 5 cells (A1:E1).
I will always know the starting Cell.
Any help would be much appreciated.
Not sure i understand the question - what do you want to know?
do you want to know how to develop a function that uses a range - if so, any
do you want to know how to create a dynamic range - if so, check out dynamic
ranges at www.contextures.com/tiptech.html
"ACase" <A...Chart Coloring
I need a way to select the color for the bars in a bar chart befor the
creation of the chart. I know how to select the colors once the chart is
created, is there a way to automatically change the chart colors?
You can change the default colours Excel uses for chart fills and lines
respectively, in Tools/Options/Color. The colours from left to right are the
ones Excel picks for your data series in order of selection. Select the
colour to be changed and click Modify... The rest is evident I gather. In
the same pane you can also import colours from another workbook (e.g., your
company...A Tricky Question! Macro & Chart
I have a very tricky problem here. I have a column chart which has sa
4 columns - namely, A, B, C and D.
First Issue - I would like to check is it possible to assign a specifi
macro for A, B, C, and D to their respective columns?
Second Issue - And as each macro has its own codes, would it b
possible for the macro to be so smart that if I click on the column fo
A, A macro will run...
Please note that the order of the columns will change over time as
will sort the values and put the one with the highest value as th
Kindly advice me whether the above are possible.....Charting Data to Compare
I have the following data to chart (Using Excel 2003)
It's for several different hospitals and I want a chart for each hospital.
I want to compare 4 quarters from the year 2005 & 2006 (side by side) in a
bar graph for each year and then the YTD data as well (side by side). The
YTD is the sum of the 4 quarters. I want this all on one chart. The data is
Q1 Q2 Q3 Q4 YTD
2005 2134 1958 2647 2016 8755
2006 2149 2034 2457 2314 8954
The chart will have 10 bars, Q1 side by side, Q2...textures in charts
I am familiar with the textures that come with excel. Are
there some other downloadable textures for excel charts
I'm not aware of any texture created specifically for Excel charts, but
there are tons of graphic files on the Web that are intended to be used as
web site background images. Many of them might work quite well for chart
textures. Start with a Google search for "web background images."
For Excel tips, macros, & downloads...
"DougC" <firstname.lastname@example.org> wrote in message
news:377201c37bbf$544a...Exploded pie charts
I want to "explode" two slices together on a pie chart.
That is 4 of the 6 pie slices would not be exploded and
the two others would be exploded as a single wedge but
with two different colors. Any hints or solutions?
In Excel, you can only explode a pie chart uniformly. You can't just
blow up independent wedges.
One workaround is to hold Shift while selecting Copy Picture from the
Edit menu, selecting the On Screen and As Picture options, pasting the
picture of the chart, and ungrouping it. Now you can move the wedges
independently. I didn't like the way ...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" <email@example.com> wrote in message
news:06d401c39d0d...Area Chart showing percentage?
I'm a newbie that created an Area Chart using the Graph Wizard. It's
almost what I need, except the Y-axis shows an accumulated count of
the values. What I need is to normalized the values so that they
represent a percentage. E.g., the total across the X-Axis is always
100% and the chart shows the percentage contribution of each value
80___ _________ _
60 \/ /\ \___/
40 /\______/ \ __
The SQL generated by the Wizard:
TRANSFO...Forgot to put in the Board of Directors on my org chart in Excel
How can I add a top position to my org chart without having to redo the
entire thing... we have 170 boxes and I left out the top dog! I don't have a
budget for any new programs so I have to use what I have.
what version of Excel are you using? I suppose you created the org chart
using the Diagram tool? If so you are going to have to fake it. Create a
second org chart using the same tool. Select the entire second level and
delete it, this will leave a single box. Size the box down to the size you
need and drag it to the top of your original org chart. It won't...Does any Chart Y-axis with 2 Values on X-axis(A train's tracking)
I need to draw a chart, where Y-axis represent Railway
Stations and X-axis represent times of a day.
I need to show simple line chart Stating From Station A,
0700hr(Train Dep Time);Station B 0800hr(Train arrive
time);Station B 0800hr(Train Dep Time);Station C 0830hr
(Train Arrive Time);Station C 0835hr(Train Dep Time);and
finally Station D 0900hr(Train Arrive Time).
You can see that in some station, the train does not stop
and so Arrive and Dep time are the same. But in some
stations, the train stops and therefore the line chart
will show as parallel to X axis during its stops at th...Excel
My son is trying to reverse the x and y axis on an Excel chart. I don't
believe you can but I thought I should ask.
> My son is trying to reverse the x and y axis on an Excel chart. I don't
> believe you can but I thought I should ask. <
One way is to select the chart, then choose Chart | Source Data | Series,
and respecify the ranges for X Values and Y Values.
"Mike Middleton" wrote:
> DenisB -
> > My son is trying to reverse the x and y axis on an Excel chart. I don't
> > believe y...Helped with stacked bar chart and percentages
I am attempting to create a stacked chart with two data series (one
representing the number ontime orders, and the other late). I would
like to have a label on each bar that would tell the percentage of
ontime. Perhaps someone would have a good example?
Thanks for your help,
Calculate the percentages in additional columns. Use one of these free
Excel add-ins to apply labels from these ranges to the series in your chart:
Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com/ss
Jon Peltier, Microsoft Excel MVP
Peltie...How to combine two reports in one chart
I'm working on a shipping report that includes 3 different shipping regions.
I created new reports for each region and now I want them to be in one common
chart. How do I do that?
> I'm working on a shipping report that includes 3 different shipping
> I created new reports for each region and now I want them to be in one
> chart. How do I do that?
create a table that consolidates your three reports and base the chart
on that table.
Telyn -- 'teylyn.posterous.com' (http://teylyn.pos...Updating an excel chart on a webpage
Website is www.applestats.com
There are numerous charts in this website. Right now, I just create the
chart using the chart wizard in Excel and I copy and paste the chart into
Frontpage 2003 and publish it using http. As the data grown in the
spreadsheewts, I use to updating function to update the chart and re-copy it
to FP 2003 to republish.
There has to be a simpler wasy.
I would like to put the spreadsheets in a folder in the webfile, and as I
update the numbers, have the charts on the web pages update with the new data.
Is this possible?
I do not know scrip...automatically create chart upon selecting
I have a spreadsheet containing about 50 different
financial ratios for 2002 thru the current month. I want
to be able to click on the name of the ratio and have a
chart automatically generate using all historical data
thru the current month, thus including each month as it
is added. Does anyone have any suggestions?
On Wed, 29 Oct 2003 07:43:30 -0800, Jason <firstname.lastname@example.org> wrot=
> I have a spreadsheet containing about 50 different
> financial ratios for 2002 thru the current month. I want
> to be able to click on the name of the ratio and have a
> char...Display significance in charts
I have a number of bar charts and I need to show which
points are statistcially significant to the others without
manual manipulation of data labels or bar chart colors.
Is there anyway for me to automatically show
significance? I'm looking for some way to either have
both number and text in my data sheet or for my numbers to
be colored in the data portion and also charted that color
Any ideas would be appreciated.
You could use Rob Bovey's Chart Labeler to automatically manipulate the
data labels (it's free at http://appsp...Trouble. Visio 2003 SP1 ORGANIZATION CHART WIZARD
I got a trouble using Visio 2003 SP1 ORGANIZATION CHART WIZARD.
I want to import org data from Exchange using ORGANIZATION CHART WIZARD
and customize the fields to load and draw in the shapes.
So, I found HOWTO articles in MSDN and also in Office Online
Assistance. The article name - "Create an organization chart from a
data file using the command line or Run method"
Also I used examples from Microsoft Office Visio Code Librarian to
write a C# solution. This solution will help me to automate the process