100% stacked column/clustered column
I have a 100% stacked column chart (12 columns). The first two columns show data for:
The next two shows data for:
and so on.
I want to have EUN 2002 and EUN2003 placed without any space (as in a clustered column chart). Similarly for EUS 2002 and EUS 2003
Hi Hans -
Through careful arrangement of the data in your worksheet, you can make
a stacked column chart that looks like a clustered-stacked column chart.
There is a tutorial showing this technique on Bernard Liengme's site:
http://www.stfx.ca/peop...Appending Pairs of Column Data!
Say in sheet named ABC, I have data in 6 columns [(A, B), (C, D), (E,
F)] their lengths vary, which I want to move into sheet BBB and put
them ALL in 2 columns only (A, B)....i.e. append them
What is the smart way to do so?
What determines which go into each of your 2 new ones?
=ABC!A2&" "&ABC!B2&" "&ABC!C2
=ABC!D2&" "&ABC!E2&" "&ABC!F2
> Say in sheet named ABC, I have data in 6 columns [(A, B), (C, D), (E,
> F)...Chart with One Column Column and Two Stacked Columns
I need to create a chart that shows a target to be achieved, and two stacked
columns showing results by department and also by how the results are split
(salaries and ODOE).
Can anyone help? I can do the target and one or the other way of the
results being shown, but I can't combine.
I figured it out :)
> Hi There,
> I need to create a chart that shows a target to be achieved, and two stacked
> columns showing results by department and also by how the results are split
> (salaries and ODOE).
> Can a...Line-Column 2 axes Help
I can't seem to set up a line/column graph and format it correctly. I have
over 10 series of elevation data and corresponding dates from one worksheet,
and precipitation data and corresponding dates from another worksheet.
I have the the elevation series plotted to the 2nd x axis (date) and the
precipitation series plotted to the 1st x asis (date). Precip data on the
left y axis and Elevation data on the right y axis.
Ideally, what I want is line graphs for the elevation data and bar chart for
the precip data. I can either get ALL the data to be line graph data, or one
of my ele...how to format data with an input mask like ss# (***-**-****)
I am trying to format text with an input mask like the one used for a SS#.
But what iI need would look like this (***-***-***-**-***). Is there a way to
add this to the "canned" format selection?
Thanks in advance for your help
Try Format Cells -> NUmber -> Custom
> I am trying to format text with an input mask like the one used for a SS#.
> But what iI need would look like this (***-***-***-**-***). Is there a way to
> add this to the "canned" format selection?
> Thanks in adva...Multiple Information in Columns
I have mutliple information in my columns for Access 2003.
Here is an example of what I have
Report # Worksheet Location Text
3055 A103 XYZ COmpnay
3055 A102 1231 Walnut St
3055 A104 Newark
3055 A105 NJ
3056 A103 ABC Company
3056 A102 456 Fultondale Ave
3056 A104 Twin City
3056 A105 ...Creating multiple columns from one column
I am stuck for an answer here so any help would be greatly appreciated.
What I'm trying to do is group 2 columns together and create two
columns of that group much like using the columns feature in word. I
would also like to have these columns alphabetized. It really isn't
important to me to be able to work with the file in columns, however I
would like to print with multiple columns to avoid having a 20 page
file to print.
Sort the column first using Data>Sort
The run this macro to snake from top to bottom into as many columns as you
Public Sub SplitToCols(...Data Table in Clustered Column Charts
I have created a pivot table with these data:
Count of User Year
Unit 2006 Grand Total
A 10 10
B 8 8
C 7 7
Grand Total 25 25
After that I created a Clustered Column Chart, and I am able to create a
data table with the values as shown from the table.
I would like to include another set of data as follow:
Is there any way that I can include these data (which is in the same excel
screen) in the same graph?
...formating numbers #2
For some reason when I type 6.00 in my cells, excel formats my cell as
6 and removes the zeros of the fractional part. How can I overcome this
"Sam" <firstname.lastname@example.org> wrote in message
> For some reason when I type 6.00 in my cells, excel formats my cell as
> 6 and removes the zeros of the fractional part. How can I overcome this
> problem ?
Select the cell, column or row where you want two decimals. Select
Format|Cells and click on Numbers. Make su...Urgent please: What save format to use
I'm very new to Visio. I am creating simple drawings out of basic shapes,
lines and text. I am using Ariel 12 point bold type.
What format should I save it as please? Currently I am using .png. The
drawings look OK in print, but the text looks particularly blurry and
indistinct both in print and on screen.
This is due today, so I would appreciate speedy help
why not just print the visio from visio?
"Soccerman58" <Soccerman58@discussions.microsoft.com> wrote in message
> I'm ...Make a bell curve chart
i have a spreadsheet with results of a 5k race, 950 finishers.
i am trying to make a bell curve chart that shows the rate at which
finishers come in;
i changed the time to a decimal by using the formula "=(C2-INT(C2))*24"
that helped, and i now have a valid line chart
i trying to show that the majority of finishers are between 8 - 11 minutes,
some before and lots after.
any ideas on this?
I suggest that you consider using a histogram, i.e., a column chart of a
frequency distribution. (The histogram may or may not have a bell shape,
depending on your data....Extract some fields from a Row to a column
Apreciate your help in advance.
This is my problem I have a Database w/ four columns but in my firs
column starts row A, Co. Name, RowB Address, Row C Phone #. I
Columns # 3 and 4 have their City Name ,State Zip Code respectivibly
I'll like to put this rows in columns.
PS From Sunny South Florid
VicV's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1463
View this thread: http://www.excelforum.com/showthread.php?threadid=26266
not really sure how your ...data input format
I have a user entry form and need to ensure the correct data format is used
when entering. At the moment it is a text box on a VBA data entry form, I
want to code the text box to only accept dd/mm/yy format.
If you get the dat as a string, then you can perform very specific tests on
parts of that string. For example:
Dim s As String, i As Integer
s = Application.InputBox(prompt:="Date?", Type:=2)
If Len(s) <> 8 Then
MsgBox "Bad Format"
ary = Split(s, "/")
If UBound...Senders Name is blank in Relpy column.
We have Outlook 2002. And it is configured for Connect
and Offline use.
We have selected the option, "In folders other than Inbox,
save replies with original message" selected".
When working in Offline mode, and you reply to an email
from a folder other than the Inbox, it will save the reply
with the original message, but when you view the list of
emails, the senders name in the "From" column is blank.
You can open the email, and the senders name is listed in
the "From" line.
This is not an issue when working in Connect mode.
...Dynamic Charts #7
I have a 2 column data set that I need to chart. The last row of this
dataset can increase or decrease. I need the chart to reflect the values
For this, I am calculating the last row value in the macro and transferring
it to the variable "lr".
When I try to introduce the value of lr in the following statement and run
it, I get an error "Run-time error '1004': Method 'run' of object
activechart.setsourcedata source:=sheets(custname).range("c1:d" & lr & "),
Does ...multiply entire column by %
I need to multpy all of the cell contents (currency) of a single column by a
specific percentage. Basically what I'm doing is taking a list of product
costs and calculating markups. Anyhelp would be greatly appreciated as I am
at a total lost and can't find help anywhere
If you want to multiply by a percentage:
In an empty cell enter the percentage, say .25.
Now copy that cell. Then select the range of cells that
you want to change and do Edit>Paste Special>Multiply>OK.
Now, if you want to increase those cells by a percentage,
in the empty cell e...renaming columns
is there a way to rename the columns on a spreadsheet i.e. instead of A,B,C Red, Yellow, Blue
> is there a way to rename the columns on a spreadsheet i.e. instead of
A,B,C Red, Yellow, Blue
Chris Nicholas, MCSE
"A man may fail many times, but he isn't a failure until he begins to blame
No, you can't do that. But a workaround is to hide the column and row
headers (Tools - Options - View, tab, Uncheck Row & Column Headers) and use
column 1 and Row 1 for your headers. HTH Otto
"mikefromcnj&...Calculating column A * column B = Results in another column
How do i calculate a whole list in one column (B1-b6) (mathematical function
i.e. multiply, divide, summation) with another column (c1-c6) and have excel
display the output in another set of columns (d1-d6) i.e.
input X input = output by excel
b1 X c1= d1
b2 X c2= d2
b3 X c3= d3
b4 X c4= d4
without me having to change the column number row by row and insert the
value row by row after each calculation.
Enter this formula in D1...
Then just drag copy down as needed. Or, you can left double click the fill
handle. The fill handle is that little black s...Inserting graphics on excel chart is not visible
Got a chart that I inserted graphics on but when doing a print preview, it
does not show nor does it print when using excel ver 2003. Home network it
to my win7 machine office 2007 and it shows as expected. Tried the options
of selecting the graphic and bringing it to front etc. does not work in
excel 03. (I have to send it to 2003 users) What am I missing?? TIA
...Is there a way I can enter a letter to proceed text a column of ce
I need to enter a source code (letter W) before all the text that I have
listed in a column. Example: All of column C has text... MPV001, MPV002,
MPV003, ETC. I need to put a "W" in front of all the text. i.e. WMPV001,
WMPV002, WMPV003, ETC. Is there a way to do this without manually typing W
in all the cells? The spreadsheet has 1500 rows...
> I need to enter a source code (letter W) before all the text that I
> have listed in a column. Example: All of column C has text...
> MPV001, MPV002, MPV003, ETC. I need to put a "W" in front of...Rolling 12 month data charts
I was wondering if someone could give me an example to help me get my
head around the best way to do this.
I have posted before on how my charts us data tables and that I would
like to change that. I need to add annotations to specific months
that stay with the data point as the calendar year rolls to the next
What I am needing is someone to help me out by giving me an example of
what my chart should look like with the chart and then the data below
in a similar format as the data table. I have close to 35 charts that
I have to do this for and I want to make sure I start this new pro...Linking Visio chart with excel database?
I have created an organizational chart in visio 2003 and am now attempting to
link it back to the excel document. I tried using both the database wizard
and the link to database under visio extras, but no success. I cannot even
get all the way through the wizard. It will not allow me to define a table to
link the document to, and says that the connection has failed. Do i need the
ODBC tool? Is excel compliant? Please help!
If you start with Visio's Org Chart Wizard template, there's a wizard that
helps you to link various database types to an actual Org Chart featu...convert column worksheet to database
I have a worksheet containing the following columns; Article No., Article
Group, Article Description and 12 columns representing sales volume per month
(Jan to Dec). There are approximately 200 items thus 201 rows.
To able to create reports which interact with our accounting database I need
to convert the above into access database. Each record would therefore
contain Article No., Article Group, Article Description, month and respective
volume, thus approximately 12*200 records.
Could an excel/access guru advice me on how to do it!!
1) If the Access database is not created yet, creat...Varying column width in a column chart
Hi, is it possible to vary the column width in a column chart? Not all
columns together, I need every column in one chart to have a different width.
Here are some examples on producing variable width column charts,
including further links on the first example.
Silvie Dedkova wrote:
> Hi, is it possible to vary the column width in a column chart? Not all
> columns together, I need every column in one chart to have a different width.
Andy Pope, Mic...autocorrect/format spaces between sentences
Using speech to text and program only adds one space between sentences. Is
there a way to setup autocorrect or autoformat to make it two spaces between
sentences. When I used spellcheck it automaticially goes to each sentence
break for me to add that space but wondered if there is a way to
automatically do it.
There is no automatic way to add extra unnecessary spaces between sentences.
This is a word processor with proportionally spaced fonts. If you want to
adopt ancient typewriter practice, then you will have to use the replace
function to add them later.