Pie of Pie Chart type with smaller pie showing slices of main slic
How can I do the following:
Lets say I have the following labels and data
For the main pie I have A,B,C labels with A =5, B =10, and C =20. So my
main pie would show 3 slices with C being the largest slice.
To do this I highlight the 3 labels and their data and choose Insert, Pie,
Pie in a Pie to show a main pie on the left with 3 slices and a smaller solid
pie to the right with series lines connectiing them.
I want to show the solid smaller pie on the right in several slices to show
how the C slice of 20 is broken down. lets say the main slice C of 20 is made
up ...delete all macro
How can I delete all macro of my excel spreadsheet?
There are instructions here for finding and removing code:
> How can I delete all macro of my excel spreadsheet?
Excel FAQ, Tips & Book List
...Macro to generate sequentially named sheets
I have a workbook containing a 'fixed' sheet titled 'Lists' containing my
dynamic ranged lookup tables and another sheet titled 'Sheet A'.
'Sheet A' accepts input from my users and can be the first of many sheets
sequentially named, ie, 'Sheet B', 'Sheet C' etc.
Due to restrictions elsewhere, my sheets cannot be named numerically
I would like to generate a macro that can identify the latest instance of my
sequential sheets, copy that sheet into the same workbook and index the
name, ie. copy 'Sheet F' to 'S...Typing in macros
I have made a few macros and use them in word and excel
2000. When I see typed out macros on the message boards I
am not quite sure how to use them. Do I go into the
editor, type them in and then link them with a button on
the toolbar? What module do I put them in and is there
one for the personal worksheet. I have been struggling
with the syntax of Visual Basics for years. Just need a
step by step explanation.
Thank You Sue
In general, the macros you see in the groups are likely to be ordinary macros
that will go into a general module in the VBE, eg:-
Hit ALT+F11 and this will...Open File Dialog to fileter multiple file types at once...?
Here is another quick one for you all. The solution is probably simple, but
I cannot find the answer anywhere.
I have the following code:
CFileDialog OpenDlg(TRUE, NULL, NULL, OFN_ALLOWMULTISELECT |
// Later must set this to retrieve a value from the registry
OpenDlg.m_ofn.lpstrInitialDir = "c:\\";
OpenDlg.m_ofn.lpstrFilter = "txt Files\0*.txt\0Doc Files\0*.doc\0";
I am trying to get the box to filter out everything but the *.doc and the
*.txt files ... I have seen some boxes that have something that...Enable Macros question at Startup
I am getting the dialog box right when I start Excel 2003 asking if I want to
Enable Macros or Disable Macros. Problem is, I don't have any Macros defined.
How can I get rid of this message? I'm running Windows XP.
Found the answer on a previous post! Sorry - should've checked first!
> I am getting the dialog box right when I start Excel 2003 asking if I want to
> Enable Macros or Disable Macros. Problem is, I don't have any Macros defined.
> How can I get rid of this message? I'm running Windows XP.
> Thank you...Rectification of wrong posting type
There is one PL account say "Mic Expenses" has got wrong posting type
"Balance sheet", when we closed the year 2005 ,System has brought forward
the balance of that account into next year 2006, which otherwise should have
been gone into the Retain Earning of 2006, is there any option to rectify
this error, other then passing rectifying JV in 2005(coz in that case if I
take last year TB then ending balance of this account would be Zero) or
restoring the backup and doing closing procedure again.
Thanks in Advance
There is a Article ID for this in partner s...Some chart types cannot be combined with other chart types?
I am getting the above error message everytime I try to insert a chart or
any type into a completely blank presentation using either the Insert, Chart
command or the Insert Chart button in the Title and Content slide layout.
I am using 2007. Any help or suggestions would be appreciated.
Try running Office Diagnostics, Shane. Open PPT or Excel, hit the Office
button, then <app> Options | Resources. I think that may resolve this issue.
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007...macro security #5
I am unable to run a macro from my workbook as i continually get the message
telling macros are discable due to security setting being high.
I go in and change the security to Medium and even to Low and still the same
Any suggestions ?
once you change the settings you need to close the workbook & reopen it (and
choose enable macros if you are prompted) ... have you tried this?
julied_ng at hctsReMoVeThIs dot net dot au
> I am unable to run a macro from my workbook as i continually get the message
> telling macros ...Help Required with Macro to Manipulate Data
I have a spreadsheet(s) with the following data on it (this is imported
from a text file)
A B C D
1 Branch Date Total
2 4501 030204 29
4 4501 030204 14
6 4502 030204 331
8 4502 030204 52
10 4503 030204 54
12 4503 030204 85
and what do you want to achieve :-)
"Alan T >" <<Alan.T.email@example.com> schrieb im
> I have a spreadsheet(s) with the following data on it (this is
...Split data Macro
Can anyone tell me whats wrong with these two macros? Or help me with
a better one. Im trying to split the data in all cells in one column,
both these macros only work on the first row.
The data im trying to split:
Dim selectie As Range
Dim cel As Range
On Error Resume Next
Set selectie = Range(ActiveCell.Address & "," _
If selectie Is Nothing Then Exit Sub
Application.ScreenUpdating = False
Application.Calculatio...need help to declard type=IntType instead type="xsd:int" with xml schema
I am writing C# code to produce xml schema.
XmlSchemaAttribute att2 = new XmlSchemaAttribute();
att2.Name = "CustomerID";
att2.SchemaTypeName = new XmlQualifiedName("int",schemaNS);
att2.Use = XmlSchemaUse.Required;
I need to produce schema with custom data type instead of the
xsd:string or xsd:int
The code above will produce the following schema
<?xml version="1.0" encoding="utf-8"?>
<xsd:schema attributeFormDefault="unqualified" version="1.0"
xmlns:xsd=...Combine columns from seperate sheets into new sheet- macro improve
I've managed to create a macro that will take up to ten columns from one
sheet and combine them with up to ten columns from another sheet. It's
working as well as I could have hoped, but I'm positive that there are ways
to make the macro far more effecient than it currently is. For instance, for
each column I have an individual process to handle picking the column from
sheet1 and combining it with the column from sheet2 10 times - I'm sure this
process could be written to loop 10 times off one bit of code, but I'm
uncertain how to do it. Ideally, however, I...Scatterplots with different colors based on Type of Data
Is it possible to plot a scatterplot with different colors for 2 sets of data?
E.g Type of Agreement MRP Discount%
Limited 10 5%
UnLimited 20 10%
I want to show different colors for Limited & Unlimited.
Is it possible to plot scatterplots on both axis(Primary & Secondary)
Please let me know.
If I use this range to make a chart
Limited 10 5%
Unlimited ...outlook type interface
I have an SDI application and want to change it so I have a split window, on
the left I want a TreeControl above a 'PropertyGrid' control. Then my
exisiting SDI Client in the space on the right
Can anyone point in the right direction to achieve this
Any help will be much appreciated
You need to use two CSplitterWnds (as members of your CMainFrame).
Override CMainFrame::OnCreateClient and create a vertical splitter as
the main child (i.e. 1 row, 2 cols). Then you want to create a horz
splitter as a child of the left-hand pane of the main splitter (which
has 2 rows, 1 c...QAT Reference to Macros in Another Workbook Don't Stick
Running Excel 2007 under Vista. I have one workbook which will contain all
my data, and a second which contains a set of macros. By adding the second
workbook as a reference, I am able to access all of the macros from the
first. (I did have to add a dummy macro to the first workbook to get the
reference to stick.) I can add these macros to the Quick Access Toolbar in
the first workbook, and they work until I close the file; however, they are
gone when the file is re-opened. I can add my dummy macro from the first
file to the QAT, and that sticks. However, if I then add a macro fro...Macro Issue
My VBA skills are limited to using recorded macros, not writing them- so when
something won't execute... well, I'm lost.
I painstakingly recorded my actions importing 38 small text files, including
a clear contents command so that the workbook can be re-used. I have done
this successfully in the past. The macro worked after creation once, but not
after a save/close workbook. It now stalls at ' .Refresh
BackgroundQuery:=False' of the first import as displayed below, with 'run
time error 1004 - Application Defined or object - defined error
&...VSTO Excel 2003 to VB 6.0 Type mismatch
I have an Addin 2003 Application. In this Application I'm calling an VB 6.0
Dll and I send Excel Application Object as Parameter. In VB Project I'm using
Workbook_Open event with WithEvents. I have a messagebox there. Unfortunately
when i call VB dll , I get this Error Message -- > Type mismatch.
Is there any Idea?
Code in VS2008 :
private Project1.Class1 vbapp;
private void ThisAddIn_Startup(object sender, System.EventArgs e)
#region VSTO generated code
(Excel.Application)Microsoft....Set up Macro *PLEASE HELP IMPORTANT*
I'm trying to set up a macro so when i open up my bank file i could separate
all of my different accounts "pools" and i did the filter which worked well I
did the filter and it worked
> >> but one problem is when i tried it for a previous day it looked for the
> >> rows that i highlighted and this messed it up. there are times that i
> >> might have 50 rows and otehr times i might have 100 rows so i need to set
> >> it up where after i do the filter it will catch all the lines that are
> >> there.
> > your help is greatly ...Excel Macros, PLEASE HELP!
Hello all, i'm new to this forum, so could someone please help me! i'm
doing a project for university which involves me having to create
macros in excel.
Here is the problem, i have 10 links on the left side of my worksheet.
which i need to assign macros to, these macros have to link to various
charts, objects etc which are kept in additional worksheets in the same
file. anyway i can easily assign the macro to go to another worksheet to
display that chart, but how do i assign the macro so that once clicked
the chart APPEARS in the current worksheet, so the chart sits to the
right of t...predictive typing of addressee
I am frequently sending sensitive email to a person who
has a very common name.
More than once I have almost sent the email to the wrong
party because of the Outlook feature that predicts the
Does anyone know how to eliminate names from the dropdown
list that appears as you type tha addressee name?
Or is there a way to stop addressee names from appearing
automatically as you type in the "To" field.
Any help will be appreciated.
Use arrow keys to highlight error address, then hit Delete Btn
Do you use Contacts?, hitting the 'To' Btn will bri..."Can't change data type" error
I'm trying to reduce the field size of text fields in my database. They
defaulted to 255 characters when I created my database but in many cases I
only need a size of around 20. When I enter the reduced size for one field
in the table design view and try to save the change to that field I get the
"Microsoft Access can't change the data type. There isn't enough diskspace
When I click OK to the above I then get the following message:
"Errors were encountered durnig the save operation. Data types were not
changed. Properties w...How to convert CString type to LPCSTR type
I have a CString type variable, and I need to convert it's to LPCSTR
type ,what I can do!
next I want to call WinExec Command to execute this file
LPCSTR lpcstr ;
lpcstr = m_strExecFile.GetBuffer();
BUT the compilier tells me it can not convert w_char * to LPCSTR type!
ps. I use vs2005 program in UNICODE mode.
Any helpful ideas would be highly appreciated!
Why use a CString in this case at all, if all you are doing is using it in
WinExec. Something ...Inserting a blank row with a macro?
Hello everyone. Is there any way I can create a macro that will compare two
cells such as B1 and B2 and if they dont' match to insert a blank row after
B1? Thanks in advance.
If [B1].Value <> [B2].Value Then
You can usually figure out things like this by recording a macro while
you do it manually, then modify the code.
Aaron Russell wrote:
> Hello everyone. Is there any way I can create a macro that will compare two
> cells such as B1 and B2 and if they dont' match to insert a bl...Aggregate data types mismatch
Using reporting services 2008.
Getting a really weird error when calculating a variance between a budget
and actual amount in the report. Both the underlying fields are of data type
'money', but when performing the calc in the report writer, i am getting the
following error: [rsAggregateOfMixedDataTypes] The Value expression for the
textrun 'Variance_MTD_ActualvsBudget1.Paragraphs.TextRuns' uses an
aggregate function on data of varying data types. Aggregate functions other
than First, Last, Previous, Count, and CountDistinct can only aggregate data
of a si...