blood pressure charting
Blood pressure needs two readings, a Systolic and a Diastolic reading. Does
any one know how I can display readings that I have kept ove the months of
my own hypertention.
The readings need to give the date, time and the two readings, usually with
a line joining the two readings.
a tipical example of a reading is:
Experiment with this data
A B C
date sys dia
11/02/2005 10:00 130 74
12/02/2005 10:00 127 60
13/02/2005 10:00 135 75
14/02/2005 10:00 140 80
15/02/2005 10:00 160 90
I need help with a function... I'm trying to enter several data
entries(integers) from a 'User Form' into a range of cells. The entries need
to go from (B44:j79) one at a time - clearing the entry from the 'User Form'
[textbox] after each entry. I can get the data in the first cell (B44), but
it will not advance to the next cell down - or clear the entry after I hit
the <enter> key. Here is what I have already:
Private Sub TextBoxEnterData_Change()
For Each Cell In Worksheets("Data Sheet").Range("b44:j79")
...Chart template not saving title formats
Hi - I have a chart saved as a template and everything is formatted correctly
when applied to a new chart, except the chart and axis titles. The category
and value axis values maintain the formatting that was stored with the chart.
It's just the titles for the chart, category axis and value axis that I have
to always reformat.
Hi Tammy, chart templates will not save titles. Privacy was one of the
concerns when considering that templates could be shared broadly without
knowledge of what the template might contain.
This posting is p...CREATE Excel from WORD Table
Looking for help to - Find text, replace with carriage return in cell.
Previous posts most helpful in converting badly formatted Word table to
formatted Excel worksheet. The goal is to copy bulleted cells in Word
to become bulleted cells in Excel. I replace ^t^t and ^p with "zz" in
Word doc. Then copy to Excel. That prevents bulleted lists becoming
separate cells in Excel. Now I want to find "zz" and replace with
"Alt-Return" for a carriage return within the cell. Obviously looking
for simple solution for newbie.
CRITICAL NEED: I'm looking for a macro...Automatically shift chart data range
I have a spreadsheet full of charts based on monthly data. The charts
are intended to show a year's worth of information, i.e., April 2009
to March 2010. There are a series of cells in the spreadsheet with the
chart that are autoupdated with new information that the charts are
Since there are so many of these charts to update each month, I'd like
to know if there is a way to have them automatically shift their date
ranges for each new month. For example, Chart A shows data from April
2009 to March 2010. Now that April is here, the chart needs to be
shifted to show ...3 month rolling chart
I've looked at some examples but found myself lost. I have a sheet that
shows overtime by department (those being the rows) by month (columns), and
wanted to make a chart that will show a rolling three months for each
department, so it would show August, July, and June, and next month Sept,
Aug, July. I know I have to use the Name function and Offset in some terms
but am somewhat lost. The department names start in A7 and go down, the
months start B4 and go across. Any help would be appreciated.
In article <FFBCC27A-3B21-4F71-991D-6A86A2A2B51F@microsoft.com>,
Shanin@discu...How do I format a notpad document into Excel?
I've downloaded a document from Notepad to Excel. How can I format it to
different columns, or utilize the way it is now and it would print out each
line without cutting off portions of each line?
Try Data>Text to Columns to break it out into columns.
Delimited by space or comma ot tab or whatever.
Actually Notepad should generate a *.txt file.
Open that directly in Excel and the Text Wizard should pop up.
Gord Dibben MS Excel MVP
On Mon, 7 Aug 2006 17:43:01 -0700, Clara_Sheppard@sbcglobal.net
>I'v...Excel to PDG Format Error
I am used to using Excel 2007 to convert my workbooks into PDF's. However,
recently, all of a sudden, everytime I PDF a workbook my Formating and graphs
are all wrong. I have noticed that this only happens when I do multiple
sheets, but the problem with doing individual ones is that I can't combine
them with reader.
Try Dr. Dan's All-Purpose Excel-PDF Cure:
Select all worksheets by <ctrl> or <shift> clicking
from the menu bar: File > Page Setup
click into the Page Quality box, and select 600dpi, if it already says
600dpi, select it again.
I have created an extensive Excel file. After I have set-
up my page format, and print, the file reverts back to
original default. how can I set up my page format and
retain for future use. Time consuming to set-up each time
I enter data. t
...Linking Excel to a Access database
I have created a query that is retrieving data from an Oracle database.
Unfortunately I am now retrieving more than 65,000 lines of data and th
worksheet can't handle the growth in data. I could break the query int
several parts to reduce the number of lines retrieved to each worksheet
but I think this problem will keep occurring with the growth in th
We are using excel macros to count information in the data retrieved.
My boss wants the data in Excel to create graphs etc.
Is it possible to retrieve the data into Access and then use th
existing functions to count the data without...Charting in EXCEL
I want to create a chart in EXCEL that, year by year, shows the range of a
certain variable with four stacked bars for quartiles of a universe. I
think I can figure out how to do this.
On each of those annual bars, I would also like to show the relative
position of two special extra data points. Probably they would be indicated
by a diamond and a circle, or something like that.
Though I know I could manually paste a diamond or circle onto each of these
yearly automated stacked bars in nearly the correct position, that would be
messy and a bit of work. And so I ask: Will EXCEL allow me to ...Excel 1997
I know, I know......
It's time to upgrade my microsoft office software, but right now I can't
afford it. So I'm stuck still using my Office '97 edition. Anyway, I was
wondering if there was any way to hide the contents of a specific cell so
that when I printed the page the contents would not be seen.
Does anyone know how I might go about doing that?
You could change the colour of the characters in that cell to white, but
don't forget to change it back or you will never see it on screen.
Remove yourhat to reply b...Pareto charts and Run Charts
I need help in making Pareto Chats and Run Charts.
One way to get such help is to use search engine like Google, Bing, etc.
Search for "Excel Pareto Chart" or "Excel Runs Chart" (without the quote
Many items, including a Microsoft template, will show up.
If you need help with a specific question when you create your chart, post
Be sure to include your Excel version.
"aliya.pawaskar" <email@example.com> wrote in message
...Strange Excel 2003 Grouping Problem
Something is happening that is strange on my clients computer.
Whenever she opens more than 1 excel document (lets say she opens 2)
they are automatically grouped on the task bar.
Note: This only happens with excel files. Grouping is off in the
taskbar properties. I have updated, done a repair, uninstalled/
reinstalled but it still happens. Is there a setting *in* excel 2003
that forces all documents to merge as one instance on the taskbar?
There's an option in excel:
Tools|Options|View tab|Windows in taskbar
And there's an option in Windows (I use winxp...Displaying cell data in a chart
Previous posts indicate a successfuly method for displaying data/text from a
cell into a chart. Following this procedure, I select the chart, press the
equal sign, and select the cell, and then enter. The address of the sheet
and the cell address are displayed after the equal sign. When I press enter
nothing seems to happen. The data are supposed to display in the middle of
the chart, but I do not get any display of the data. I am in a Pivot Table
worksheet but did not directly insert a Pivot Chart. I used getpivotdata and
created new cells for plotting into the inserted column ch...Programming involving applications other than Excel
My Excel VBA programming is decent enough when I stay within Excel.
However, I'm trying to expand my knowledge base and frequently I wish
I could better interact with other Office programs, such as Outlook.
Here's a piece of code that works great but I don't fully understand.
Private Sub UserForm_Activate()
Dim x As Integer
Set objOL = CreateObject("Outlook.Application")
Set olNS = objOL.GetNamespace("MAPI")
Set myFolder = olNS.GetDefaultFolder(10)
Set myItems = myFolder.Items
x = 0
For Each myConta...Cut and paste causes Excel to hang
A couple of our users are having a problem cutting and pasting cells. After
a while using Excel doing a cut and paste of even a single cell causes it to
Task manager shows no load on CPU or memory. The workbooks are always the
same and other users can work with the document without problems. The
problem occurs with new workbooks, blank workbooks. Running 'detect and
repair does not resolve the issue. The only thing that fixes it is to cancel
the process (temporary fix) or restart the computer which seems to reset
something for the day. Any ideas?
Is it possible to have a chart's source data cover ten series, but to chart
only the series where values are populated, i.e. if there is no value and
just blank text, it wont be charted?
I'd like the entire chart including the legend to be smart enough to exclude
is there any way to do this?
Help would be greatly appreciated!
No, not at the series level -- well, at least not without VBA
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <BD...Excel Formula Poser
This is a multi-part message in MIME format.
I have created a worksheet to provide details of resources. Within the
worksheet are separate sheets for each month this financial year (i.e.
Feb 2007 - March 2008)
Along the top I have three separate rows with differing rates for
different clients and below, I have a number of sections for those
different clients which list different projects.
Within each of these sections are formulae in the form:
=(C6*C15)+...Do not update chart
how can I save a chart so it does not update like when using pivottables?
Jon Peltier has instructions for delinking a chart:
> how can I save a chart so it does not update like when using pivottables?
Excel FAQ, Tips & Book List
Thanks a lot Debra!!
"Debra Dalgleish" <dsd@contexturesXSPAM.com> skrev i meddelandet
> Jon Pelti...Cell protection in Excel is lost when file is uploaded to website.
I set up protection in the usual way, and certain cells are locked, as I
want, on my local drive. But, when I FTP this file up to my website, cell
locking (protection) is lost.
...Stack Charts? ? ? Please help
I am trying to produce a stack chart with a difference ! I Have got a
list of depots which i want to analyse and four columns containing data
(bit like below). Basically i want two stack "bars" for each depot.
Depot, Days Outstanding, Turnaround Time, Ttl Tickets Opened, Cust -
1-231 3 1 3 1
1-922 2 1 2 1
I want days outstanding and turnaround time in one stack and then the
second stack will be the remaining two columns side by side.
Is this possible ? ? ?
Or should i add this to the list of questions for Bill?
Is there a way in which a chart can be automatically made to modify its data
range? I have a spreadsheet into which we have a lot of charts. On a regular
basis, we add extra data ( cut and paste from another spreadsheet), and then
have to spend a long period of time modifying the ranges of each of the
charts in order to account for the new data. Is there a way in which a chart
setup is such that it looks at a whole column, rather than a specific array
Short answer: Dynamic Charts
Re...Deleting workbook in Office EXCEL 2007
Good evening ~ I have a problem that is driving me nuts. When I click on the
office button in EXCEL, all of my workbooks appear. There are 3 of the 10 I
no longer use and don't need. I can delete the file thru Open, right ckick
and "delete." However, the name of the file remains in my list when I click
on the Office button. The file is gone but the name remains. How do I get rid
of this??? Please help before I go crazy. Thank you.
If you are talking of the recently-used file list, I don't believe that you
can remove individual files from that list....How do I select multiple rows randomly in MS Excel?
How do I select multiple rows randomly in MS Excel?
Select your first row and then hold down the Ctrl key while selecting the
> How do I select multiple rows randomly in MS Excel?
"Varun" <Varun@discussions.microsoft.com> wrote
> How do I select multiple rows randomly in MS Excel?
Just another angle to the post's interp ..
(with emphasis on "randomly")
Here's an example set-up to play with ..
Assume we have 6 rows of data below
in Sheet1's A1:C6:
Data1 Text1 Desc1
Data2 Text2 Desc2