Stacked, but not total
I have 3 Totals.
Total 1: 92
Total 2: 87
Total 3 (an overall total which includes total 1 and 2, but other amounts):
I would like stacked column to show totals 1 and 2 and show total 3, but not
adding it to totals 1 and 2 (to show the overall amount, with 1 and 2 inside
it). Any ideas?
Start with a stacked column. Move "Total 1" to a secondary axis, then "Total
2". Note that you may need to right click on one of these series, and pick
chart type - stacked again. Right-click on chart, chart options. On the axes
tab, ac...3-D Frequency Chart in VBA
I currently have a frequency chart (3-D Column Chart) that reports the
frequency of an item within a range and also in what distance that
range appears. I wanted to know if anyone has any suggestions on how to
automate this task.
I first have to locate the distance ranges and then I perform a IF AND
statement to see if the item appears in the distance range then it
copies that item value in a cell if not then return nothing:
Then from there I setup a frequency array to get the frequency of the
previous search and what percent range the items fall in:
=FREQUENCY(AA$10...Adding Excel VBA Macro to a Custom Category
We have managed to add a custom category for our functions which are in an
addin. How do we add the functions to the category of funcitons. Do we have
to recreate these as Excel 4 macros whilst referencing the VBA macros? Any
examples would be useful and if we reference direct to a dll, how would this
differ to referencing the VBA macros in the addin?
Thanks in advance
...Clear CheckBoxes using VBA
Greeting and Happy Holidays to all,
I have a workbook which contains a Master Log. On that sheet is
command button which copies another worksheet in the Workbook, clean
out the previous data from the new copy, making it ready for new dat
On this Worksheet that gets copied there are 10-15 Checkboxes. The
perform no function other than to mark certain choices. Specifically
they are not tied to a Macro or a VBA routine.
What I would like to do is simply reset them so they are al
"unchecked" in the new copy. I have tried recording a macro whil
manually unchecking the boxes in ...Multiple Stacked Bars
Here is my data set:
2007 East 2007 West 2006 East 2006 West
Sid a b c
Nancy e f g
Johnny i j k
Salesman n n1 n2 n3
I want to have a stacked chart with Salesmen 1-n on the X-axis.
And a bar for 2007 and a bar for 2006 for each. I can ...Stacked Columns
Using Excel 2003. Have five stacked columns. Want to change order of only
one stack; the only one that has more than two values in its stack. Was able
to shift order of one of the two stack columns but the one with three values
doesn't give me the same screen that permitted me to move the order up or
Disregard! Found it!
"jaygreg" <firstname.lastname@example.org> wrote in message
> Using Excel 2003. Have five stacked columns. Want to change order of only
> one stack; the only one that has more than two values in it...excel function to call solver (VBA Macro)
I want to know how to have a function call solver. Without any user
prompts or "alt + key". I just want a cell to contain [
=Solver(A1,3,0,B2) ] and be able to copy and paste this so the next
row is [ =Solver(A2,3,0,B2) ] I don't really care what the return
value is for the function. I just want it to set A1 to 0 by changing
B1. I have seen a bunch of people ask this question but have found no
answers? Can you even do this with excel?
If I understand your question well, you want to change a cell from within a
That is not possible. A functi...VBA
What are the commands / syntax to change the Startup settings from VBA, and
where could I go besides here to get that info?
Thank you. I really appreciate all your help..
Hello "Programmer - wannaB".
"Programmer - wannaB" wrote:
> What are the commands / syntax to change the Startup settings from
> VBA, and where could I go besides here to get that info?
This should work in Access 2003 as well:
Hello Wolfgang, Thank you, that is just what I was looking for.
I have a standard database which i need to upload it into my accounting
software. In this database, one column is sale amount whereby sometime the
value is NIL.
Is anyone know how to write VBA to run down that particular column to delete
those row with sale amount is NIL?
Thank you so much in advance.
> I have a standard database which i need to upload it into my accounting
> software. In this database, one column is sale amount whereby sometime the
> value is NIL.
> Is anyone know how to write VBA to run down that particular column to delete
> th...need vba help to clean up database #2
I tried to run this function and it didn't work. It asks me to update
values and brings up a file search window. No matter what I do it just
says name in the cells when I do the last function. The first function
works fine but the second function is what confuses me.
twist's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16055
View this thread: http://www.excelforum.com/showthread.php?threadid=275142
The 2nd formula in Sheet2 is reading: Sheet1
Think you're getting the e...Multiple Columns in a stacked column chart
Is it possible to create multiple columns of stacked data
sets? For example: can I plot monthly data in which each
month is the sum of 3 categories, but plot these stacked
columns for 2 years (side by side per month)? This
enables me to compare last years monthly totals versus
this years monthly totals on a per month basis?
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/people/blie...Create Folders in Directory with Excel VBA?
Is there a way to create folders with a specfic names, and have them
saved in a directory. I have an excel file with 250 records with my
desired folder names.
I want to avoid having to through the process of selecting <File | New
| Folder> then naming the folder -- 250 times!
I imagine there's an easier way with VBA... please help!
It can be done something like this. Attatch code to a command button on the
Alter code to suit your reqirements. Test on a dummy workbook first until
you get it to work the way you want.
Please note that there are practical lim...Sort/re-order a stacked bar chart
I have a stacked bar chart and I would like to sort or re-order the the
values so that the largest value is lowest and the smallest value is highest.
How can I do that?
I am running Excel 2007.
You will need to sort the under lying data.
Not clear whether you want to sort on total value of stack, in which case
you will need a helper cell to sum the values and sort on.
Otherwise sort your data on one of the series within the stack.
Andy Pope, Microsoft MVP - Excel
"PJFry" <PJFry@discussions.microsoft.com> w...Provide the full stack
How can I provide the full stack of a custom assembly, Web service, business
objects, and data access on project server 2007.
Not sure about your exact question, but check the SDK.
"Ahmed Ghaith" <AhmedGhaith@discussions.microsoft.com> wrote in message
> Dear All,
> How can I provide the full stack of a custom assembly, Web service,
> objects, and data access on project server 2007.
...How do I create a TextBox on a DialogSheet in VBA?
I have tried, without success, to add a TextBox to a newly created
DialogSheet. Other controls were created using the 'Add' method, like
'ActiveSheet.Buttons.Add' or 'ActiveSheet.CheckBoxes.Add', but the TextBox
control doesn't accept this method. Any suggestions?
> I have tried, without success, to add a TextBox to a newly created
> DialogSheet. Other controls were created using the 'Add' method, like
> 'ActiveSheet.Buttons.Add' o...Changing Multiple Tab Colors based on lookup value VBA?????
I am very new to VBA and am looking for help with the following
My workbook contains ten tabs that link back to a central sheet. I
would like the color of each tab to change (Green vs No Color) based
on whether a certain cell in each tab meets a certain requirement.
Example: If cell (V1) in tabs 1, 2 & 5 = "Yes" then color the tab
green else no color. Note, (V1) is a lookup function that gives a
value from the central sheet. The remaining tabs (3, 6,7,8,9 & 10)
would have no color since the lookup function is not equal to "Yes".
Note, the central ...VBA Editor in MSExcel
I am using VBA Editor in MSExcel. I forgot the password for VBA Project. How
can i view the code?
...VBA in Excel
Halo, im a newbie 2 both VBA and Excel, I was assigned to design a VB
script which can post query and retrieve data from an excel sheet, i
it possible to do so?..If yes, what is the 1st step should
follow?....and im a newbie 2 visual basic as well.
Here is an example of my requirements...
Lets said I post a query, Select all employee from emp1 where sex
female and age > 20, and the VBA will retrieve the data from exce
which match the query...
I jus know this can b done by a Java program with a linking to acces
pls...tis is urgent, any1 can help??
Using Office 2003
I would like to reset any custom filter settings from all columns.
The following resets Column 1 only:
What is the VBA code to reset Columns 1-17?
You could have found that out by yourself if you had just used Macro Record
(as I did).
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Dennis" <email@example.com> wrote in message
news:961i10teu4q5r2t6rh38bmen6lski9r6f6@...Cannot load VBA to record macro
I cannot load VBA to record a macro on any of the office
programs on my computer. Any ideas are welcome!
I have OSx 10.2. office v.X 10.1.5.
The error that I receive: from excel=>tools=>macro=>vba
Microsoft Visual Basic
'Visual Basic for Applications\4' could not be loaded
out of memory
(This still occurs when no other program is open, so I
assume it's not really a memory problem...)
I have tried unistalling and reinstalling the entire office
package but it didn't help.
I have no problem opening the RealBasic e...stacked bar graphs
Is there a way of conditionally formatting the fill colour of seperat
segments on a stacked bar graph.
My chart has a different colour for each segment at the moment. I wa
wondering if it was possible to say have the segment of the chart t
be the same fill colour as the source data cell fill colour.
I am using Office 2000 and am fairly new to VBA.
Thanks in advance,
Message posted from http://www.ExcelForum.com
You can have VBA see the color of the cell, and apply it to the chart
element, but if the cells have conditional formatting, it's gonna cost
you a gre...VBA Learning Resources
I notice a lot of the solutions in this NG involve macros programmed in VBA.
Can you recommend any books or other learning materials for VBA?
Below you find links to the best Excel sites and to a book list.
Start with books from John Walkenbach.
From Norman Harker:
Here's a bit of a summary collation of Excel resources posted
originally in response to a question on how to become an Excel Expert.
Perhaps the very best resource is yourself! Few experts have gained
their in-depth knowledge other than by banging their heads on the
keyb...100% stacked column chart with negative numbers
How do you create a 100% stacked column chart with negative numbers? After I
create the chart it only goes up to 80%
How do you want it to show? The total length (including negative amount) of
the column should equal 100%. (make sure you haven't limited the scale of
your y-axis) What the graph is showing you is that the positive numbers do
not account for 100% of your data.
*Remember to click "yes" if this post helped you!*
> How do you create a 100% stacked column chart with negative numbers? After I
> create th...Deleting Blank lines with VBA
Help I have a macro that runs multiple formulas. However, when the formulas
finished I am left with about 64000 blank lines. I am unable to insert a
row on the
worksheets as I get a Run-Time Error 1004 (Try to locate the last Nonblank
Here is a same of some of the formulas I am running ( the macro is very
ActiveWorkbook.Names.Add Name:="TrunkFormulaI", RefersToR1C1:="=Trunks!R1C27"
ActiveWorkbook.Names.Add Name:="TrunkFormulaJ", RefersToR1C1:="=Trunks!R1C28"
ActiveWorkbook.Names.Add Name:="TrunkFormulaK&qu...Stacked Chart Colours Disappear
I have a stacked bar chart. When I view it on my screen it is in color
However when I do a print preview or I copy it as a picture it turn
into a black and white chart. I can't figure out how to display to ge
it to copy in color. I originally thought it had something to with th
patterns I was using in my stacked bars, but after removing th
patterns, I still have the same problem.
What it is going on?
Message posted from http://www.ExcelForum.com