Excel Content Type issue, shows default not assigned type.
Question about the way Content Types work between Word and Excel.
I have a several content types set up 6 using Excel and one using Word. I'm
seeing a weird behavior, where when I associated the content types with a
document library, and select new on the Toolbar. In the document properties
panel, the Word document shows the content type that is assigned however the
Excel documents show the document libraries default content type, and there
are no options to change it until I save the document.
1. I create a library to house the documents used as templates for the
...Legend on Chart
I am updating chart that includes three years of data and want to add 2008.
The data has transferred, but the legend shows 2007,2008,2006. How can I get
2008,2007,2006 in order in the legend?
Change the order of the series. Double click on one series, and go to the
Series Order tab.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Double L" <Double L@discussions.microsoft.com> wrote in message
>I am updating char...Demographic chart?
I need to create a demographic chart in Excel, but I can't find the proper
chart type. Is there a suitable chart type? I've gone through all options I
can think of for a regular bar chart. (In my world, a demographic chart is a
bar chart with the values pointing in two different directions... Not very
complicated, but Excel doesn't seem to agree with me!) Does anyone know of an
They are also known as Tornado charts or population pyramids.
http://tushar-mehta.com/excel/software/torna...Send and Receive Option
On my desktop I have send and receive button/tab.
Some how on my notebook, I have failed to check this option and so it does
not show up. Could someone please help me to find where to check so that I
always have at hand the option to send and receive. I would be grateful
MS Office Outlook 2007
Thanks for any help
> On my desktop I have send and receive button/tab.
> Some how on my notebook, I have failed to check this option and so it does
> not show up. Could someone please help me to find where to check so that I
> always have at hand the opti...Excel 2007 Line Chart with Markers
I'm using a Line Chart With Markers tracking 4 data lines:
Red with Circles
Black with Squares
Blue with Diamonds
Yellow with Triangles
The yellow with triangles is very light and doesn't show very well in my PP
presentation. I would like to change the color of just that one line. How
do I do that?
Click on that series in the chart, and right click, format series. You should
now be able to change the color of the series.
*Remember to click "yes" if this post helped you!*
> I'm using a Line Chart With Markers...Charting/ Graph question
I'd like to visually display a table that contains the following table
StaffName Software 1 Skill Level Software 2 Skill Level (10
software titles >)
(around 50-60 people)
What i'd like to is output a simple visual output that shows me how
many people are at a particular level for the each software (but all
on one chart). I imagined that it may be nice to see blobs based on
the size of the number of staff at a particular skill level for the
However i am not sure if this is the right way to represent this data.
I've created a se...Excel Export Options
I'm exporting a list from CRM 3.0 to Excel 2003. When I do so, I don't
get the option to select whether I want static data or an active link
to the data. Therefore, when I email the spreadsheet to someone
outside the network, it doesn't contain data.
However, my colleague does get the options pop-up, so I guess I've a
configuration issue somewhere. Any idea where I look to change this so
I get the option?
On 22 Oct, 18:17, rich...@draig.co.uk wrote:
Wait, ignore me, I'm an idiot, I think it did work ok. I disconnected
from the network and I was able to open...*.zip files not showing up in Insert File dialog box
My boss is trying to attach a ZIP file to an email. But when she
navigates to the folder with the ZIP files (and she is showing all
files *.*), the ZIP files are not showing up in the Insert File dialog
box. We can go to the folder in Windows Explorer and we see the ZIP
files there. She is using MS Outlook 2003 SP1.
I have showed her a work around so she can attach the files
(dragging), but I'm curious as to why they are not showing up in the
Insert File diag. box.
Any help will be greatly appreciated,
I've seen this just once and am told a reboo...quick charting question for similar charts on multiple sheets
Hi, just wondering if there is a quick solution to my problem. I have
several charts, all virtually identical except for the data values in
them, and i have one chart per sheet, and about 100 sheets.
The problem is that some charts are positioned slightly different on
their respective sheets then others on other sheets, although some are
identical from sheet to sheet aswell. Just wondering if there is a
quick way to select them all, line them up identically on each sheet,
with all the same size/formating etc.?
-----------------------------------------------------...Chart in Chart
I currently using a 3 line chart, which is controlled by a scroll bar
What I need is to have a smaller chart, but magnified of the visabl
data for a period of days within the chart timeline. All I need to kno
is how to add a addional line chart in and excisting chart.
Hope you can assist
Thiem's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2747
View this thread: http://www.excelforum.com/showthread.php?threadid=49068
You can embed charts within a chartsheet but y...Debra Dalgleish-help with worksheet data entry
I browsed your website and found this new data entry
worksheet(http://contextures.com/xlForm02.html) which was very good and
i showed my boss.He liked the idea of it and thus asked me to work on
it.I managed to add a few more fields and it worked fine.
I have a cell named "Documentation to support requirement" at B11 and
its corresponding text box at D11.My problem now is that at D11, i need
two kind of controls one is drop down list box for document type and
another control is text box for document name.How do i achieve this? i
need both of this control's answer to b...Data summary
I have a 13 sheet report with each line a different date and each column
different data, I want to puul date specific data to a summary sheet using
date entry on the summary sheet ie. 04/10/10 = 04/10/10 on each line of the
data sheets and I want to pull the data from column A,B,F,G
I hope I have explained this clearly
...Trouble with Pivot Tables & Named Ranges
Can I use a dynamic named range setup in one file as a range in pivot tables
in another file?
When I have the data source file (with the named range) and the pivot report
files open, the pivot reports update just fine. But the moment I close the
source data, the pivot reports no longer can update and I get a message that
the source can't be found. If I reopen the source, the pivot tables work
fine again - but as soon as I close it up, the reports no longer work.
The source file is very large and I don't want to open it every time I have
to update all the reports tha...Show summerised data
I'm using vb.net 2005. I have an app with a Form containing a Tab control
with 5 pages. 1 page records time booked to a particular job using a
DataGridView control. All works OK. The question, how do I place on the same
Tab as the DataGridView a summary of hours recorded.
I have a Group By query with a Sum function that summerises the hours by
job category in the Hours TableAdaptor. Its being able to display query
results on the Tab that I can't do. Guidance most welcome.
I have set up a spread sheet with five option boxes so that only one can be
highlighted at one time.
I now want another set on the same spread sheet. If I draw a new option box
and select it - it deselects all the others.
Any ideas on how to set up different option boxes groups -
- one set only allows one to be selected at a time
- Another will allow both to be selected etc.....
Group them. If forms optionbuttons, then draw a frame or group box around
connected buttons, if control toolbox buttons, set the GroupName property
"Ciara" <Ciara@discussi...How do I create a chart....
I would like to create a chart that counts the exact number of a specific
name compared to other names. The names are in the same column but each cell
may contains a differnt name and I would like to count how many times each
name appears in the column and then compare them in a graph.
try selecting the column (A)?
select unique values
select a cell for the data to start (C1)
hit enter and copy down to the end of the C Column.
> I would like to create a chart that counts ...Format of data import from a database
I have a spreadsheet that has data imported from SQL Server or even MS
Access that has dollar amount fields. The field is coming over as a text
field and even if I format the cells as currency it won't apply the
formatting until I actually double click in the cell and press enter.
Is there a way to fix this for the entire spreadsheet so I don't have to
click in each cell to force the formatting to work? This spreadsheet as
over 1500 rows of data. I get this every time I export data from either SQL
Server 2000 or Microsoft Access Database.
Any help or information is greatly apprecia...charts: 1. link to a cell in chart titles, 2. custom chart template
how can i make a link to a cell in chart title, category axis & value axis?
i'd like to know how to make a title like eg below:
[=B2], [=B3]' <- in line below (smaller font size than in line above)
how can i make a my own chart (custom type) by making a own template (how to make a template, and how to implement it to excel
custom types charts)
i am interested in making types similar denkin diagram (similar to radar type) or leontief branch flow matrix (similar to x-y plot
with columns and rows with second x axis and second y axis)
is there a...Problem in opening the Connectivity Options....
Using - Wince 6.0 Visual studio 2005.
When i click "Connectivity Options..." i get a popup window "Platform
Builder was unable to read the device settings from the Datastore" (This
is popped up by c:\Program Files\Microsoft Visual Studio 8\Common
I have searched for this topic and tried the suggested solutions such as
deleting the folder CoreCon under Document and settings directories etc.
But nothing seems to work... Should I have to reinstall the Wince 6.0 ?
or Visual Studio 2005 ?
This problem started when I had to reinstall the vi...Chart items moving around
I have posted this before but I never got any replies so I did some testing
myself. I I want to share what I have found out with you and it would be
great to hear if someone else recognizes this.
I have a number of embedded charts on a scorecard sheet that gets updated
from several sources. I run this scorecard for different business units, take
pictures of the scorecards and put in another Excel file that I later make a
Problem: After running this a few times, I find that my chart legends have
moved around a bit and that some plot areas have been resi...Split Transactions not Showing in Expense Reports (MNY2007)
Hi .. I'm a long time Quicken user thinking of moving from Q2002 H&B
to Money 2007 H&B since I was able to get that version. I converted my
file and all seemed ok. I'm now comparing reports from Q to Mny, and
they're not adding up.
So far I've found that several split transactions (and I assume all)
do not show up in my report. For example, I split a $100 cash debit
between $10 parking expense and $40 meals. The remaining $50 is
uncategorized. The parking and meals do not show up in my report. To
me, the transaction looks good. I've got other parking & meals
tr...Simple State Diagram flow chart in Visio?
I am trying to make a very simple State Chart Diagram in Visio.
I'm not sure if I should just use the basic flow chart or not, as I'm not
familar with UML.
I simply want to describe a software program that will move two one of four
"states" based on some conditions, then loop back around.
I am not opposed to just making a flow chart but was hoping to make it look
a little more "professional" using a State Diagram.
The examples seem rather complicated, I don't want to have to define
variables and all that using UML, I just want to show the four "states...sort FUNCTION SPLITS DATA INTO TWO GROUPS
I'm using Excel '97. I had two versions of a spreadsheet I was using,
and copied several lines of data from one and pasted them into the
other. Now, when I sort the larger of the two the data separates into
two groups. The pasted data (or newly added data) sorts first, and
then the original material sorts as a second group. I've tried
reformatting the columns, etc. and an stumped. Any ideas?
Message posted from http://www.ExcelForum.com/
assuming the data you are sorting on is numeric, it sounds as though one set
of data is truly numeric data and the other is see...Combination of stock chart and line chart
Dose anyone know how to plot a stock chart and a line chart together in
combination ? I tried but can't seem to do it, is it possible in Excel ?
One way is stock chart with open, high, low and close plus volume but I need
to plot 2 other lines.
I have written an explanation on this web page:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> Dose anyone know how to plot a stock chart and a...showing the contents of dynamic cells
If I use the following spread sheet as an example
a b c
1 23 2 34
2 22 23 75
3 3 45 32
I am trying to find the value of rows 1 and 2 but only for the column where
c row 3 is the highest.
I.e. in this example as 3b is the highest how I can show the values of b1
How ever it is important to remember that all the 9 values in this spread
sheet are dynamic.
Finding the max number in row 3 is easy =Max(a3:c3)
One way ..
Source table assumed in A1:C3