Chart two variables with differing values
I'd like to chart data similar to:
Year 2000 2001 2002 2003 2004
Thefts 75 120 95 101
Veh. Mfg. 100,200 125000 130000 145000 125000
I want to produce a chart with the year on the abcissa and with the Thefts
scale on left ordinate and Veh. Mfg on the right ordinate and have the scales
I'm running Excel 2002. Seems i can't select the Format/Selected Series data
Series/Secondary Axis to set the scales correctly.
I'd like to get som...In Excel how do I label the axis of a chart with 2 sets of labels
I wish to put two labels on a chart say a time function together with a
quantity function against the same axis (usually x).
I run Excel 2003
If you plot two series You can select one of them and change the axis to
In chart options you can then modify the Y axies as needed.
> I wish to put two labels on a chart say a time function together with a
> quantity function against the same axis (usually x).
> I run Excel 2003
If it's a category axis, put the two sets of labels into adjacent
columns (or rows), select the chart and choose Source D...How do I copy an Excel chart with added text boxes into Word or P.
I have created a chart in Excel and added a number of text boxes on top of
I need to paste the entire chart & text boxes into Word and/or Powerpoint;
however by selecting the chart and copying, the text boxes are excluded.
MS help suggests entering the text boxes outside the chart then moving them
into the chart and grouping the chart and text boxes; however there does not
seem to be the ability to group the chart with the text boxes.
If you had clicked on the chart before making the textboxes, all the items
would have been grouped. But you can do it later:
Hold down SHI...charting a single changing DDE cell
I have a spreadsheet that captures real time stock data via a DDE link. The
cell captures the last price of a stock as it changes over time. Can you
chart that changing cell as the day progresses. Maybe capture the data and
then chart it or a macro which plots that cell every minute?
You would need to capture the value of that changing cell periodically
in a growing table, possibly in a different sheet.
For example, every time you update it via the DDE, you could run a code
that copies the value of the cell to the last row of the table.
Use a dynamic chart to plot the values in t...can open 1 picture unless logged in as Administrator???
Unless i log in as Administrator, i can only insert 1 picture in MS
I get told the graphics filters are not installed, but i have done a full
Ms clients are running windows 2000 OS and are locked down via group policy.
Any help would be great
Publisher (especially the older versions I hear) doesn't like playing with
MVP Microsoft [Publisher]
"Carlos1981" <Carlos1981@discussions.microsoft.com> wrote in message
> Help p...Special teen picture directory!
We've got new teen * 'XXNX' (xxnx.xxxanalmovies.info) * pictures
directory for you! Free and direct!
http://xxnx.xxxanalmovies.info Team, 2006.
xmoviexmasterx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37385
View this thread: http://www.excelforum.com/showthread.php?threadid=570987
How to create intersectionso if the hight of bar crosses that line the color
of the bar should from that point.
From Level 0 - 2:- RED Color
From Level 2 - 4:- Green color
From Level 4 - 6:- Blue color
You will need to use 3 series to build the stack. Simplest way is to use a
cluster chart, setting the overlap value to 100, with data base on formula.
If you have the following data in A2:B9
A2: =<leave empty> B2: =SeriesName
A3: =A B3: =0
A4: =B B4: =1
A5: =C B5: =2
A6: =D B6: =3
A7: =E B7 =4
A8: =F B8: =5
A9: =G B9: =6
You can then create the following ...combination chart #8
How can I get a combo chart with 3 series - one as a vertical
bar/column, and 2 series as lines, with 2 y axes?
I only seem to be able to get one series in line format, while the
first two insist on viewing as vertical bars, regardless of whether
they are assigned to the primary or secondary y axis.
Right click each series and set the chart type property of the series
> How can I get a combo chart with 3 series - one as a vertical
> bar/column, and 2 series as lines, with 2 y axes?
> I only seem to be able to get one series in line format, while the
> fir...Two charttype on chart
Hi, I have export the data to excel from Vb, then add the graph in excel
and set my secondary axis as..
..SeriesCollection(4).AxisGroup = xlSecondary
then how we set this group only as chatrtype as xlLine
and the primary axis values by Column charttype
Message posted via http://www.officekb.com
..SeriesCollection(4).AxisGroup = xlSecondary
..SeriesCollection(4).ChartType = xlLine
shah firdaous via OfficeKB.com wrote:
> Hi, I have export the data to excel from Vb, then add the graph in excel
> and set my secondary axis as..
> .SeriesCollection(4).Axi...Sorting in Pivot Charts
I'm using Access 2003 & am trying to sort in a Pivot Chart. I have a single
series & I'm trying to sort by the qty of that series. Thanks much in
...Link chart format to a cell
I want to create a chart that changes format depending on value in a special
For exemple a bar chart that for one value have blue bars (the whole chart)
and for another value red bars?
On Thu, 26 Jun 2008, in microsoft.public.excel.charting,
vito <firstname.lastname@example.org> said:
>I want to create a chart that changes format depending on value in a special
>For exemple a bar chart that for one value have blue bars (the whole chart)
>and for another value red bars?
You can't, it's not possible in Excel. But you can have two series, one
which...Use the same cell from many worksheets to create a chart?
I have a new worksheet for each day, labeled with the date. I want to pull
data from the same cell (like "P-3") in each worksheet and put it into a
Example: On ten worksheets, pull the data from cell P-3 (arbitrarily called
"income"). Then, put that P-3 data into a chart that tracks daily income: the
date itself (taken from the worksheet name) plus the data.
Any idea how to do this?
You need to create a summary region on a worksheet, and use this as the
data source for your chart. See this page for more details:
http://peltiertech.com/Excel/ChartsHowTo/Char...Setting Major tick to none on charts is not working, is it a bug?
I've tried to set the major tick for my x-axis to none, so that the marks
only show up above my data points along the x-axis... it is not working
I notice a small change from None to Cross, but it basically looks the same
as cross, just a little bit shorter on both ends(inside and outside).
Anyone know if this is being fixed, if it's a bug... or if I'm doing it
I can change it with both XY Scatter charts and Line charts. What type of
chart are you trying to change?
"Mike J" <Mike J@discussions.microsoft.com> wrote in message
news:9EFDB3C7-1CBD-4...Updating a chart, within a workspace
I keep a daily log of a particular price, plus its moving
average. I use an Excel spreadsheet for this. Under a
separate tab, I have set up a Chart, that visually tracks
both the daily log of price, and the moving average.
I need a simple method for updating the chart. So far,
the only method I can find that works is to "Clear"
[delete] each plot on the chart, and then use "Copy,
Paste" to achieve an updated Chart plot of the two
parameters. This is laborious, since I have to re-do my
color and line preferences each time. There must surely
be a more elegant m...Display data points that are less than the chart trendline
I have a standard chart with an x and y axis and a linear trend line.
Is it possible to have the chart to only display the values that are less
than the trend line?
Thank you in advance for your help.
Sure you can. Firstly, either hide your existing data points, or make them a
very pale grey colour.
Then, assume your x values are in A1:A10, and your y values are in B1:B10.
In say A12, calculate the slope of the trendline with =SLOPE(B1:B10,A1:A10)
and in say A13 calculate the intercept using =INTERCEPT(B1:B10,A1:A10)
In column C, calculate the corresponding y value for each x value fr...pictures of
'pictures of trains' (http://www.funny-pictures-2010.info)
...Problem formatting date values in chart...
I have a blood pressure tracking spreadsheet -- at a minimum, it tracks
Systolic and Diastolic pressure for a given day.
A B C
E.g.: Date Systolic Diastolic
1 9/3/04 120 90
2 9/4/04 123 87
3 9/5/04 129 79
I currently have a simple line graph that shows systolic data points over
diastolic data points.
The left hand (Y axis) value is "Pressure".
My problem is that I want the "date" values of Col. A to display at the
bottom of the graph as a label with each corresponding data point and...How do I Add a variable in the legend without charting the data?
I have three variables that need to appear in my legend but only two of them
should appear in the chart. How do I show the third variable in the legend
without it being plotted in the chart?
You can add a third series to the chart so that the legend item appears
but set the data to be plotted to be zero or #N/A such that the column
or line is not displayed.
Legends vs Plotting wrote:
> I have three variables that need to appear in my legend but only two of them
> should appear in the chart. How do I show the third variable in the legend
> without it being p...Saving pictures to My Pictures
I have Publisher 2002, Windows XP. I've worked with Publisher for years so
I'm pretty comfortable with how it works.
My question is about saving pictures. 99% of the pictures I edit in
Publisher are then saved in designated folders in My Pictures. No matter if I
select File, Save As or right-click and select Save as Picture, I always have
to follow the same procedure:
1. Save My Documents
2. Select file "My Pictures"
3. Select designated project folder
3. Change type from gif (default) to jpeg
I've gone into Tools, Options to modify these settings and so far I...Pie of Pie Chart #2
How is the "Pie of Pie" chart used? I know this is the
chart I need, I just don't know how to plot the data.
I have 3 discrepancies - Broken 85%, Misplaced 10% and
Incomplete 5%. I want to create a pie chart that shows
the 3 discrepancies. I also want another chart that has
4 different sub-discrepancies for broken. Example:
Broken1 50%, Broken2 25%, Broken3 15% and Broken4 10% -
How can I plot this data and create the chart I need?
Hi Karen -
List the data like this:
Broken4 ...what happened to[LINK] chart-wrksht,when not same page? (same Wrkb
I have a chart, on separate pg...same Wrkbk. Selcting a Series - does not
'outline' it's data returning to the Wrksht.
How do you EDIT?
Simply selecting the series will not change sheet to show you data as
you have discovered. Try using the Source Data dialog, this will allow
you to swap sheets and see and adjust the data used.
> I have a chart, on separate pg...same Wrkbk. Selcting a Series - does not
> 'outline' it's data returning to the Wrksht.
> How do you EDIT?
&...A mjultiple Line/Data on a single chart
I need to create a chart to show each individual Community $/sft range in
comparison. I can not get excel to create the x axis on a range from 693 sqft
(lowest) to 1346 (highest) and then place the $ tick where it should fall
into the sqft amount for that price. Excel either picks up 1 of the three
sqft ranges (it wont create a range), (or) labels each sqft ft as series
1,2,3,4,5,6,7, etc...My Series are the Community Names, not the sqft amounts.
I can't figure out what I am doing wrong. My boss needs this graph for a
meeting today at a meeting - Please Help
Milano Terrace aka Shad...Creat a chart to show peak usage times for a resource
I'm no genius at Excel (2002 or 2003)and I could really use some help
on the best way to display some data I have.
What it shows is the usage of a training drop-in room, with details of
the arrival time and period spent / per user / per day. There seems
far too much data to put into a chart in any way that I can think of,
but I really would like to be able to illustrate the spread and volume
of clients throughout each day.
Please can anyone give me simplistic information on how best to creat
this as a visual report so that we can easily summarise usage
Any ideas would be ap...Too many data points in Excel Chart
I am using Excel 2003 and I have several sets of data, each with hundreds of
When I create a bar graph (with data table), because of the quantity of
data, all the bars are so thin and cramped together that they are drawn as
black. The worse part is the data table is not readable anymore because
Excel try to put all the data into the table.
I think Excel 97 used to be alright, it will just pick a few points and put
that into data table so that it is readable.
Is there any way to tweak excel so that the graph (esp. data table) is more
PS, I try not to create separat...Excel Only Lets me put 11 items in a chart!
I tried to only put 12 items in a chart for at least 2
hours put Excel only lets me put in 11 items!! Please
help! I don't get it because word will let me put at
least 12 and more!! I've reimstalled Excel and download
all updates and it still doesn't work!
There's a limit to the number of characters that you can enter in the
Data Range box.
As a workaround, you could define the range of cells that you want to
use, and enter the range name in the Data Range box. There are some
instructions here for creating a named range: