How to add a blank line in a combobox
I want to add a blank line to a combobox, but still limit the entries
The lines in the combobox come from a table.
On Oct 16, 6:53 am, mieke <mieke.lam...@gmail.com> wrote:
> I want to add a blank line to a combobox, but still limit the entries
> The lines in the combobox come from a table.
I believe you will have to load the combo box in the forms load
event. Unless you want to create a blank record in the table, then
you will have to change the rowsource type of the combo box to value
list, and create a list by looping through the r...Grouping of chart.
I have 4 charts in a sheet. all charts are overlapped on
by one.I have used transparent method. Now i want to print this char
in to another sheet or document use copy and paste command. But i coul
not able to print it. I can print the first chart only. There is an
method available for group the chart? So i can copy the all the chart
Thanks and Regards,
ramkumar_cpt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2867
View this thread: http://www....Pivot Chart #12
Is there any way to show Grand totals on the Pivot charts and make them stay
as you change the views?
...Not all my data is showing up in my chart...
I highlight all the data I want to plot in the XY Scatter chart (8 rows of
data) Only 7 rows are plotted though. There are no formulas or anything.
Can someone please help me.
What does in show under "Source Data" for the chart?
My guess is that it may have taken the first row of data and used that as
the X values. The usual advice from Jon Peltier (the charting guru) is that
you leave the top-left hand corner cell empty, so that Excel recognises the
first row (if your data is in rows) as X values, and also recognises the
first column as series labels.
Even if you haven'...How to invoke host email client and add attachements
In my MFC application, how can I invoke the host email client and add
attachements as well as supply an email address etc.
I dont want to send the CDocument derived class, but files that it manages.
searching seems to centre around MAPI but cannot find something recent and
relative to the specific thing I want to do...
On Thu, 10 Jul 2008 02:24:05 -0700, PRMARJORAM
>In my MFC application, how can I invoke the host email client and add
>attachements as well as supply an email address etc.
>I don...Pivot Table Error...Help! #3
> You most likely deleted a column header that is in the range of th
> pivot table. Doublecheck to make sure all your column headings withi
> the pivot table range are not blank.
you were correct, someone at my office delete the data in 4 of the 2
columns. that's what was throwing the pivot table error.
molavi111's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1461
View this thread: http://www.excelforum.com/showthread.php?threadid=26427
...Chart sheet labels in Excel 2007
The names on invididual chart sheets sometimes revert to generic names Chart
1, Chart 2, etc. This never happened with Excel 97. What causes the sheet
name to change? How can I prevent this from happening?
This happens to me as well. I've made a half attempt to get an answer from
Microsoft tech support, but with no luck.
I wonder if it might occur in workbooks where data is retrieved from an
outside source. Has that been your experience?
> The names on invididual chart sheets sometimes revert to generic names Chart
> 1, Cha...Pivot Table Group by one field but sum another
I have a pivot table that I need to sum the Number Affect by the Group
Date. Here is example of layout:
Site DATE EQUIPMENT NUMBER AFFECTED
MACON 38726 SHELF42703 1
38732 SHELF12703 14
38737 SHELF62703 13
38738 SHELF42703 1
Here is what I am trying to accomplish:
Site DATE EQUIPMENT NUMBER AFFECTED
MACON 38726 SHELF42703 1
38726 Sum of Number Affected 1
38732 SHELF12703 14
38732 Sum of Number Affected 44
...How do wrap all columns of a pivot table to 2nd half of same page
I have a 3 column pivot table that can be too long to fit on one page, but I
do not want to shrink it to fit (makes type too small) Is there a way to get
the rows that don't fit on the page to wrap and print as a 3 column table on
2nd half (open half) of the page?
If you are asking whether you can wrap text in a pivot table - yes, the same
way you do it in a spreadsheet - Format, Cells, Alignment, Wrap text
I don't think this is what you are after but ... If you are asking can you
extend the printout across multiple pages, look at this and see if it
addresses anything you ...Changing the Increments on how a chart is displayed
To Who Ever Can Help:
I'm trying to change the way my y-axis displays units of
time. I'd like it to display units of time starting with
4:00am going to 10:00am with 15 minute intervals:
Can someone give me a clue on how to do this? I sure do
appreciate any help I can get.
> I'm trying to change the way my y-axis displays units of
> time. I'd like it to display units of time starting with
> 4:00am going to 10:00am with 15 minute intervals:
I'll assume that you don't...How can I add Paste Special to the Word 2007 context menu?
Excel 2007's context menu includes Paste Special; Word's does not. I have
frequent need for Paste Special in Word and the many trips to the Ribbon get
tiresome. I'd like to know how to add commands to the context menu in
general, but a solution for Paste Special is the immediate need.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://...Pivot Table-Change Data Source? Excel 2007
I need to update a series of pivot tables by adding 2010 data. What's the
best way to do so? Add the updated info to the source document and refresh,
or create a new data source and refresh all the tables? Does the new source
have to have the columns in the same order as the previous?
If I create a new source document, how do I tell the tables to change the
source? Other responses to this question say to rightclick a cell and use the
wizard. I'm using Excel2007 and right clicking doesn't produce a wizard.
To change the date source of a PivotTable in Excel...Bubble chart- names for values
how do I assign names to the values in a bubble chart?
have a look at the following add-ins which will do this for you as
Excel does not support this automatically
> how do I assign names to the values in a bubble chart?
...How do I show range of data in an area chart?
I am trying to show various toxins across the bottom of a chart, and ranges
(from 0.001 to 1,000,000) on the left-hand side...OR whatever will work. I
have ppb-PID (0.01-1,000), IR (0.50-1,500), Electrochem (0.1-1,005), ppm-PID
(0.1-10,000), FID (0.75-50,000), Tubes (1-150,000), LEL (1.5-100,000), Oxygen
(1,000-150,000), and TC (10,000-1,000,000) and can't seem to find anyway to
portray CORRECTLY what I want to show. Thought perhaps a bar graph, then
thought probably an area chart would work--but I can't figure out how to
enter the ranges, since they're all different and d...Charting Time Samples
I have a spread sheet with a time value in hours:minutes:seconds in
column A and another on column B with a value in hours:minutes:seconds.
In column C is the difference betwen the two. (=TEXT(B1-A1,"h:mm:ss")
with a results like this....
How do I chart these time samp...how do I add cells totals
what i need to do is a monlthly sales forcast, example:
Unit Cost X how many sold = total + (jan/05 (previous) month's total =
(current month Feb/05) total
30 X 65 = total (1950) + 930 = total
I need to do this from Jan thur Dec on each line/service.
Do all the numbers exist in the current sheet?
A = unit cost
B = total amt. sold
C = previous sales
D = this formula:
Please keep all correspondence within the Group, so all may benefit!
"Joe" &...Pivot Chart- 2 unrelated series on 1 chart
I have a set of warranty orders that each have a date when the product was
originally shipped and a date when a problem was reported. I am trying to
make a pivot chart with months on the x-axis and counts on the y-axis. I
want 2 series, one that shows how many orders were shipped in each month and
one that shows how many problems were reported each month. I do not want to
show the relationship between the report and ship dates, just unique counts
of each based on date. Is this possible? Here is an example of what my data
looks like, I have about 6,000 entries so there are significa...Help
I have a basic pivot table in which I inserted an outside filter to provide
the top 10% of the grand totals. Now, I would like to do a chart of some
that would show only that data that I filtered. I have tried, but it keeps
coming back with the full set of data from the original pivot.
Any help is appreciated.
...How to add a button to a form?
the Account form and will do a very simple field validation when clicked?
Any help will be appreciated
I would add a button to the Account toolbar, using the isv.config.xml.
Something like this:
<ToolBar ValidForCreate = "1" ValidForUpdate="1">
Take a look at the SDK for the specifics on is...Copying a Worksheet with a Chart
I want to copy a worksheet from one workbook
(DemoSheets.xls) to a newly created one (Right click on
the worksheet tab, click on Move or copy..., ...). This
seems to work fine when there are no charts on the
worksheet to being copied. However, when there is a
chart, Excel seems to be adding a name and reference to
Book1.xls for each name that was in DemoSheets.xls. These
names look like "='[Demo Sheets.xls]Gas Prices'!$B$5" when
they shouldn't be there at all.
The problem is experienced on Excel 2002 only when there
is a chart on the worksheet.
Is there any...Chart
Is there a way to create a chart that has 3 data bars on
the primary axis and 1 line on a secondary axis?
(Similar to the custom chart LINE-COLUMN ON 2 AXES but
with 3 column bars.)
Create a column chart from your data. Then, right-click on the series
that you want as a line, and choose Chart Type from the menu.
Select the Line category, and one of the Line subtypes, click OK.
Jon Peltier has instructions for creating your own combination charts:
> Is there a way to create a chart that has 3 data bars o...Deleting a chart
I am just starting to work w/ charts. I know that this must seem like an
incredibly elementary question - how do you delete an entire chart from a
Select the chart.
Hit the Delete button.
"GeorgeJ" <GeorgeJ@discussions.microsoft.com> wrote in message
>I am just starting to work w/ charts. I know that this must seem like an
> incredibly elementary question - how do you delete an entire chart from a
...Filter out zero sums in a pivot table
I am trying to create a Pivot Table report using a lot of data that may sum
to zero in the pivot table. Is there a way to filter out the lines that
equal zero in a pivot table or do I have to work with the original data
before I create the pivot table?
...auto expand line chart
I would like to place a line graph into a spread sheet which needs to
continue to grow as we move through years 2007 & 2008 but dont want the graph
to show a zero value for future dates and only add them as the months move
hope this makes sense and you understand what I mean.
You can use the dynamic charting approach, see Jon's pages on the subject.
Can anyone help? I what to add a logarithmic trendline but the option is greyed out and I can't seem to find where the addin might be. I am working with Excel business 2000.
There is no add-in. Sounds as if the data is not amenable to a log fit.Are
there negative values? Is the x-axis numeric?
"Gee" <email@example.com> wrote in message
> Can anyone help? I what to add a logarithmic trendline but the option is
greyed out and I can't seem to find where the addin might be. I am worki...