Line Chart-EXACT End Date
This has come up several times on "tests" I have taken for jobs. I have
gotten this to work in the past by playing with the scale but I am sure there
is a better way to do it.
I want to create a line chart based on dates where the end date shows on the
axis. The data doesn't have a common denominator that makes sense so I am
stumped. If I had my choice I would use a Scatter as I can make those dates
behave but I need to do it with a Line Chart.
Have tried the Time/Scale axis as well as the Category option.
One easy way in a line chart is to sort the worksheet ...Re: How can I change size of chart Legend without losing half of the contents?
"Chris Mitchell" <chris.a.mitchell@NOSPAMbtinternet.com> wrote in message
> When I try to resize the Legend associated with a chart I can't reduce it
> without losing half of the content, and in order to show all of the
> content the Legend has to be so big it takes up nearly half the chart.
> There are only 6 or 7 entries in the Legend, but the space between each of
> them is enormous. If this was in MS Word I'd fix it by changing the
> Paragraph settings and reducing the space before and after ea...Draw statistical Charts
I always wonder is it possible to draw statistical Charts as in Excel the
same in an Access reports. Any VBA code links, url I would appreciate it
...Charting macro for creating multiple charts on multiple sheets
I have a 26 workbooks with about 100 worksheets for tracking stocks.
It is in the form of a table. It has date, open, low, high, close
volume, and adjusted close for the headers. Each worksheet is named
after the stock ticker name such as ATT. I am trying to create a macro
which will go through each sheet from a list in column C of a sheet
called Insurt and create 3 charts on each sheet. One with the prices
and dates excluding the volume for the entire table, approximately
1500 rows. The second chart is for 250 rows, approximately 1 year, and
the third chart is for 50 rows, approximately 3 mon...XY
I once had a link to an XY program that could place
descriptions automatically above each point. My computer
has been upgraded and unfortunately I cannot find the
link. Can anyone help me.
You can use Rob Bovey's XY Chart Labeler to add labels. It's a free
add-in that you can download from his web site:
> I once had a link to an XY program that could place
> descriptions automatically above each point. My computer
> has been upgraded and unfortunately I cannot find the
> link. Can anyone...where do i get a SIPOC diagram template?
John... Visio MVP
Need stencils or ideas? http://visio.mvps.org/3rdparty.htm
Need VBA examples? http://visio.mvps.org/VBA.htm
Visio Wishlist http://visio.mvps.org/wish_list.htm
"Carlos" <Carlos@discussions.microsoft.com> wrote in message
On Sun, 26 Nov 2006 16:45:01 -0800, Carlos
>where do i get a SIPOC diagram template?
enter "SIPOC Visio template" gives you...expression as a value of a table
Hi all,I have a table that contains numbers and names of tables all in onefield,the type of the records for the table is text.is it posible to request to convert the value to a value of a table aspart of SQL sentence?...Customising Gantt Chart
I've been able to produce a Gantt chart, sort of like I want it to be by
using this macro: http://support.microsoft.com/kb/213447. However I need to
do some tweaking:
I want task 2 to start where task 1 ended, etc. Somehow I'm not able to
figure it out
The Red Special
In order to start task2 where task1 ends you need to sum the values in
Assuming Task1 information is in cells B4:D4 then the start date of Task2 in
cell B5 would be
And for more information on gantt charts see,
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=3...Upgraded to Office 2007, area chart messed up
I just upgraded to Office 2007, now my area charts need to be fixed.
I have been using stacked area charts. Now 2007 has added a line from the
origin to the last data value for each series and shades the areas for that
series above and below the line.
I simply want the shading to go from the X-axis up to the first series, and
then from each series up to the next series.
How can I fix the area chart?
...How to remove a field value using Bulk Edit
Does anyone know how to remove a field value using Bulk Edit? The goal is to
make the field blank for all selected records.
Hello, I want to create a chart, which has a slider, and when the slider is
constantly clicked the area under a curve from a chart starts progressively
being coloured (filled) until it reaches the end of the curve and the end of
the slider. How can create these types of charts.
The example near the bottom of this page:
shows how to use a slider to control which data is charted. Ignore that my
example uses dates, and just set it up for whatever units your X-axis uses.
Jon Peltier, Microsoft Excel M...chart
how to create a new chart?
highlight your information, Insert, chart, choose the one that you want to
see, you can change it later
if this helps please click yes, thanks
"mona s ibrahim" wrote:
> how to create a new chart?
...How to get rid of Adobe add-in?
I have eliminated Adobe's additions to
MS Office programs and they duly
disappeared from all programs, except
from Visio. I physically deleted the file
C:\Program Files\Adobe\Acrobat 6.0\PDFMaker\Office\PDFMVisio.vsl,
but now each time I start Visio, I get a
warning: "Visio could not find this
add-in or one of its files. This feature is
not installed. Would you like to install it now?"
I haven't been able to find where the
add-in definition resides. Can anyone help me
get rid of the nagging warning?
I'm sorry if this is an easy one but I just can't figure
I have a worksheet with 3 charts on it. I need to write
some VBA to select each chart in turn and change its axis
So I figured the first thing to do is to name the charts
so that I can select them properly in the VBA. But how do
I name a chart??? If I select the chart I get "Chart Area"
in the name box and I can't edit it.
Many thanks for any help,
As answered in .programming --
Hold the Ctrl key and click on the chart to select it.
Click in the Name Box, type a new ...Update Chart Titles with Worksheet_Change Event
I have a chart sheet called ("Histogram")with an active X dropdown box
which pulls in data from Sheet1. The Active X dropdown list sends a
number to a named cell ("ChartNumber") on Sheet1 which is then used
within 2 Index formulas to create an active range for my X and Y range
to feed my chartsheet("Histogram").
I am trying to update my chart X axis title and my X axis format using
a Worksheet_Change Event within Sheet1. I have four basic titles and
formats which I have put inside a Case Statement. However I cannot
seem to make it work. I want the Worksheet_C...xy-chart
I have kind of xy-chart.
Values on x and y varies a lot according to calculations so i would like to
fit them to my chart area.
But i would like to fit them so that x equals y, so the scale is 1:1.
- fit x according its max value (enabling 'max value' in chart)
- scale y so that 1:1 scale is achieved. (Here i can't use the 'max value'
in chart, because 1:1 scale can't be achieved)
What to do.
Thank You in advance.
Check Jon Peltier's webpage for instructions:
> I ...Dynamic Charts
I have an array of DEM (Digital Elevation Map) data.
Rows are Latitudes, Columns Longitudes.
I have created a graph (Area) that plots the elevation across Longitudes
(Column) for a given range of Latitude (Lines). Nice graph!
I would like the plot to update automatically when I glide the cursor down
the first column (Latitude), i.e. when I move the cursor down the range.
Cursor movement would be by KBoard not mouse.
I did this as a dynamic chart, with a worksheet event procedure to
update the ranges when the activecell changed.
I assumed the data was in a rectangu...Money 05 markel Total portfolio market value
I seems a simple request - but is there any way to maintain a history of
total portfolio market value and plot it on a graph report?
I'd certainly like to see that (and I'd imagine most investors would like it
as well) - but it does not appear in the list Standard Investment reports.
Or do I have to jot it down each day and enter into an Excel spreadsheet?
Many TIA - JohnS
From John Saxon
In fine Springtime Canberra
You can do it on a monthly basis using the Net Worth over Time report. If
you want it down to ind...Updating Chart fails
I have problems updating charts in Excel when using VisualBasic to
I calculate values with a self-written function "func". My sheet looks
This function "func" depends on some variables that I set in a sheet.
If I change on of this variables, I have to do a
"Application.CalculateFullRebuild" to get "y"-values updated. All
But now I have a chart that plots this x-y data. This graph is not
updated by "Application.CalculateFullRebuild". It only updates ...Office X start
Everytime I click on an Office document (word, excel, powerpoint) I
get an error 10660. But if I just start the program (click on word) it
starts up. Anyone know how to fix this?
Do a Get Info (cmd-I) on a Word document. Set it to Open With Word 2004
and click Change All.
Repeat for other programs.
Sounds like it doesn't know which application to use to open the files--the
OS may have gotten confused, perhaps if you updated Office recently?
On 10/12/05 10:19 AM, "egiraffe" wrote:
> Everytime I click on an Office document ...Alternate axis at top of chart
i have a number of X-Y scatter plots where I need to have either only an
alternate abscissa axis at top of chart or alternate ordinate on right and
abscissa on top. I can easily do the alternate ordinate but can't find a way
to do the alternate abscissa. How do I do it. the only option I see at moment
is to redraw graphs in Visio and then add the axises.
I prefer to use Excel XP but can use 07 if need be.
Thanks in advance for any suggestions!
What you need are secondary axes, and you need multiple series in order to
get secondary axes. Right click one of the series, choose Forma...org chart
As I move down the chart the print in the higher boxes shrinks. Any idea how I can stop this?
If you are using XP or 2003 you can quickly fix the problem when the chart is complete. Select the top box. Choose Select|Branch from the Toolbar, set the Font size you want. Resizing the diagram might help, too
...Dynamic Scatter Charts
I have scatter charts that will change as new data is added but I can't seem
to get my macro that adds the data labels to work with defined names. Does
anyone know if this is possible?
Thanks in advance for any help that anyone can give me!
You don't need a macro:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Neweirs" <Neweirs@discussions.microsoft.com> wr...Can I create an Excel chart from non-contiguous data cells?
Using Excel Office 2003, I'm being asked to create charts from existing
worksheets, often several within a workbook, using specific cells
(total/average cells). The cells are not adjacent to one another, but they
are identical from one worksheet to another. In my case, the cells are K15,
K29, K42, W15, W29, and W42. I'd like a separate chart for each worksheet,
and would like to have the chart automatically created once the data is in
the worksheet. Is this possible?
You can select discontiguous data by selecting one area, then holding CTRL
while selecting additional areas....Searching for values
I would like to create a report for the following:
1 - Read a worksheet with data like the following:
R 1 - John Smith A
R 2 - John Smith A
R 3 - John Smith A
R4 - Bob Jones 2
R5 - Bob Jones 1
R6 - Bob Jones 12
2 - Produce a report for every occurrence of John Smith:
R 1 - John Smith A
R 2 - John Smith A
R 3 - John Smi...