add source data to chart in excel
I can't get Excel to accept more than 19 data points for my X-axis in a
chart? Is this a limit? How do I add more data points? (As soon as I try to
add the 20th point, all of the other points are lost.)
I have had this trouble in the past. Try....
Right click chart and select 'Source Data'.
Delete any existing source data and close dialog box.
Select the source data you require and copy it.
Click on the chart and paste.
"Susan" <Susan@discussions.microsoft.com> wrote in message
> I ...Excel Pivot Table Creator Issue
I'm unable to Export to Excel my pivot table created in the Excel Pvot Table
Creator. I select my dimensions, measures, rows, and data then hit the Excel
button. I keep getting the following error:
Unhandled object exception:
Initialization of the data source failed.Check the database server or
contact your database administrator. Make sure the external database is
available, and then try the operation again. If you see this message again,
create a new data source to connect to the database.
Are SQL Analysis Services running? Were all the server setup steps com...Getting Data Shapes to Work with Custom Stencils
I imported a picture and saved it as a shape. Then I linked data from a SQL
database. I can get the data to show up in the Shape Date, but I can't get a
Data Graphic to appear.
Note that I can get Data Graphics to work with out of the box shapes in the
same drawing - just not the custom picture.
Tried in both Visio 2007 and 2010 Beta. What am I doing wrong?
Thanks in advance.
...Calculated field in pivot table #4
I'm running Excel 2002. I'm unable to create a calculated field in a pivot
table. I right-clicked on a cell in the table but I don't get the "Insert
Calculated Field" window on my drop-down list. Do I need an Add-On? Am I
doing something wrong?
Thanks for any help.
On the PivotTable toolbar, choose PivotTable>Formulas>Calculated Field
> I'm running Excel 2002. I'm unable to create a calculated field in a pivot
> table. I right-clicked on a cell in the table but I don't get the "Insert
> Calculated Field" window on my ...How to Arrange Data for Chart
I charted the following data in a clustered column chart.
Level 1 Level 2 Level 3 Level 4
FY07 - Total 167 23 20 43 81
FY08 - Total 178 22 40 26 90
These are total department errors segregated by levels for each fiscal year.
There are 3 different departments involved. What I did was just total the
errors for each FY and each level. Now my boss wants to see how many errors
were performed within each level by Dept A, Dept B and Dept C and compare the
2 fiscal years. I hope I’m explaining...Add Word and change format
1) Let say colomn A is a product codes, such as "PK0021", "UQ05P8", etc...Now
I want add a "Z" in front the codes. To be "ZPK0021, ZUQ05P8". What's the
faster way in case I got thousand of codes?
2) In my colomn B is such code as "18-521-65, 18-81-84, 18-1112-65" and etc.
Now I would like to make it to be standard to 4 digit for the middle number
to be "18-0521-65, 18-0081-84, 18-1112-65" ... As the same senario as above,
I got more than thousand of such codes... What's the faster way?
The first could be done wi...Conditional formating of Charts
I have a scatter chart and need to conditionally format points and
associated labels for each point. The condition is not related to the data
series to which the chart is linked.
Let me know if there is any specific VBA code for doing the same. You can
reach me at email@example.com
There are some non-VBA suggestions here:
To change some points of a series or some series in a chart based on a known
criterion, you can adapt one of the macros in this post:
I am creating a template which requires the user enter a time (not
present time, flight times), for example the user will be listing a
number of flight arrivals and departures and what I want to do is have
the user simply enter something like 804p and have the cell display it
as 8:04 pm. I have looked at some custom formats and nothing seems to
be able to do this. Any help would be appreciated.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
http:...Users and Asset Data linked on Form
I have two tables, one a Staff list and the other an Asset list
extracted from seperate databases, the information in the tables has
absolutely no common data, I have a form with the user name and other
bits and pieces on from the staff list and also a drop down list of
all asset numbers which I can then select the appropiate asset number
from then, that asset number and other details I would like to be
associated to that user.
I have tried, I have done this in the past about 4 years ago but I
cannot remember any of it!
Any help would most appreciated
i use microsoft outlook calendar for all our daily
appointments. i do not want to have the highlight
when i ask the assistant, i do as it says, but i cannot
click the automatice formatting (it is gray and will not
how do I get automatic formatting so that I can get rid
of the highlighting and add color
...Row Grand Totals in Pivot Tables?
I'm working in Excel 2007 and I can't seem to see my row grand totals in my
pivot table. I can see the grand totals on the columns, but no rows. Any
See if the article at
does what you want.
> I'm working in Excel 2007 and I can't seem to see my row grand totals in my
> pivot table. I can see the grand totals on the columns, but no rows. Any
Yeah, that is what I would expect it to do too. However, I set that option
and don't receive the total.
...How do I put Excel data into a US map format?
I want to feed Excel data about population and trends into a map format
instead of a bar graph or pie chart. Is there a plug-in or some such thing
that I can use that works with Excel? Ultimately, I want to have each state
depicted by a color code for a range of population or an amount of certain
I am using Excel 2002 in a Windows XP environment.
...Conditional Formatting #N/A to show white
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<br> I have several formulas that show #N/A
until a value is present
<br> I tried Conditional Formatting to turn that cell white until
a value is inserted
<br>but I don't know what I am doing..</html>
This is a multi-part message in MIME format.
Is it possible to format a portion of a text string within a cell (as opposed
to the entire cell). For example, I would like to format the word 'gift' in
red font anywhere it a appears in range C2:C417 but only that word, not the
Not with conditional formatting.
But you could change the actual format for that word (or group of characters)...
Saved from a previous post (or two!):
If you want to change the color of just the characters, you need VBA in all
You want a macro????
Option Compare Text
Application.ScreenUpdating ...how do I sum only visible data in a column
I have some rows manually hidden, Please is there a formula I can apply to
return the sum of the unhidden data contain in a column?
If you don't want to use VBA (create a UDF), you could review the following
In any case, there is a fundamental issue with both approaches: since
hiding/unhiding rows doesn't trigger any event, such event will have to be
forced from time to time, or maybe you can leave with the formulae updating
their result in the next recalculation...Can Import Email Data Filed from Office XP to Office 2003
My HD failed but I had a backup of my Office XP Pro personal file folder
with a lot of emails I needed. The file is about 128MB in size. I put a new
HD in and installed Office 2003 Pro. When I go to open the old file Outlook
2003 says that the file "is not a personal folders file". (It was backed up
to a CD ROM prior to the crash so the source file should be good.) I really
don't want to uninstall Office 2003 and put back Office XP. Any idea why
2003 won't open the file and how to work around that? Many thanks in advance
to anyone who knows the solution. Alan.
The only pro...Drop spaces from imported table
I am importing a table from another DB that has job numbers and descriptions.
My database goes off of these job numbers for referencing.
Problem is the data is imported as centered in the field.
so I end up with [ 1213 ] in my job number field.
I do have a query that runs through this table and selects the data I need,
I believe that this query would be the place to fix the "center" align.
Though I am having troubles finding how to do this
I need to end up with job numbers that have no spaces ie. 
(brackets are showing beginning and end of the field).
...Importing External Data
I keep trying to import data from an Access database and I continually get
the same error.
"ODBC Microsoft Access Driver The text file specification "Inserts" does
not exist You cannot import., export or link using this specification."
Well the spec does exist, the queries run just fine in Access. The data
source are linked text files using the "Inserts" specification, which
definitely does exist.
Sumpens wrong, but danged if I know what it is.
...Data Validation date field
I don't understand why this isn't working. I just want to make sure that
they don't put a future date in the polydate field. Is me.polydate > now()
an invalid expression?
Private Sub Form_BeforeInsert(Cancel As Integer)
If Me.PolyDate > Now() Then
Cancel = True
MsgBox "Please enter a date that falls prior to today's date"
It does not appear to be invalid. It is always helpful to post the error you
are getting and if it is a runti...Date formatting problem #5
I've tried everything I can think of with this one - help!!
I'm reading dates from 2 cells, storing them in variables, comparing them
and then storing the resulting date in a different cell.
Code currently is:
If stStoredDate<> stDate then
Activecell.Offset(0,1).Value = stStoredDate
My problem is stStoredDate = 04/09/05 (4 Sep 05 as I'm in the UK), stDate is
the same, but the value in the cell is 09/04/05 (9 Apr 05). Both cells have
identical formatting. If I change the formatting to 'general', stStoredDate=
38599, but t...How to Update the Data in RichEditView
Hi every body,
I am trying to split the RichEditView,its splitting,but i am not able
to update the data in all views.If any body knows give a suggestion.
...Transpose Address Data
Is there any way to transpose a range of data automatically? I know about
using the transpose function in Excel, but to use it I need to manually
select what I want to transpose. I have about 13000 rows that I want to
transpose (end result would be about 1000 rows of address details).
The biggest problem I have is that I can't find any thing in the list of
data that highlights where I would want to start a new range. It also looks
like not everything is a set number of rows, so I can't even transpose every
Is there anything I can do other than select, copy, paste speci...Cell format options are truncated
When you click on any cell and click to format it, tabs do not display
Are you editing the cell at the time?
You may only see the Font tab if that's the case.
Make sure you're not in edit mode before you click on Format|Cells...
> When you click on any cell and click to format it, tabs do not display
...Getting Data from another sheet? #3
WHere do I save it to
bludovico's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1480
View this thread: http://www.excelforum.com/showthread.php?threadid=26722
The manual is not ready yet (First version of the Add-in)
Save the file where you want on your PC.
Then in Excel go to Tools>Add-ins.. Browse to the file..OK
You see it in the list now (Select it)
Regards Ron de Bruin
"bludovico" <bludovico.1dribg@excelforum-...Can Windows client application read/write data to remote SQL Server database?
Can a Windows client application read/write data to a remote SQL
> Can a Windows client application read/write data to a remote SQL
> Server database?
Certainly. SQL Server is a client-server DBMS and the service often runs
remotely on a separate server.
Hope this helps.
SQL Server MVP