Scatterpoot not using X values properly -- using relative ranking

I have created a scatterplot where the X value is to be one value (risk) and the Y value is to be another (return). I've entered the X and Y value ranges properly and the y value is being plotted correctly, BUT the X value is not being plotted as the correct X value. Instead, the X value is being interpreted as the relative ranking in the list. In other words, # in list X value Y Value 1 12.2 13.7 2 10.7 11.3 etc. The graph is currently plotting the values as (1,13.7), then (2,11.3) and NOT with the corre

How do I change the color of the timeline boxes in my Ghant chart

My ghant chart automatically boxes out my time line when I input my start and end dates for each activity. How can I change the color of the time line? I want to make different activitites different colors.

Excel 2007 - publish chart as htm web page file

When I select a chart in Excel 7 and select Save As, I can choose file type Web Page (.htm file) just like in 2003, but it no longer gives the option to select just the chart. How do you save just the chart as a web page rather than the whole sheet or whole file? This was a simple processs in Excel 2003: 1. Create chart and do "Save as Web Page." 2. Click on the "Selection: Chart" radio button. 3. Set your file name and location, then click "Publish." 4. Verify the info on the Publish as Web Page display and click "Open published Web page in broswer" so that you can easily co

how to copy sheet with charts without link to original data

I have a worksheet with ten charts on it. I need to copy the worksheet with all its data and related charts to new sheets or files so I have a page for every day, with different data entered every day. But when I copy the worksheet with embedded charts and paste it into a new file, the charts pull their source data from the original worksheet, not the new one. The source data Value box is written as such, ='03-09-10'!$D$12 any ideas?

Drawing a line on a chart

Help! I need to draw a line on a chart that is horizontal - - in old Excel, the SHIFT key could be used to "snap to" the horizontal, but in Excel 2007, it does not work and it is driving me crazy!

How to set the bar with same X-axis value in same colour?

I have a bar chart showing each team's values. Total have "A, B, C, D" 4 teams. 2 teams each day. Listed in X-Axis are date and team. eg. 1 Jan A, 1 Jan B, 2 Jan C, 2 Jan D. How to set the bar's colour to be the same to individual team? Please advise! FYI, i'm using MS Office 2007.

Stack bar charts with positive and negative numbers

I am preparing a comparative stack bar graph in which both sets of data have positive and negative numbers. I would like the sum of the each data set (both positive and negative) to be reflected in the Y axis values. For example, I am graphing the gross profit of various components. The total of that gross profit in year one is $1,000. The components values are 500, 700 and -200. Is there a way to graph that in Excell 2007? The total gross profit in year two is 1,500. The component values are 1000, 700 and -200. Is there a way to grah this so that the total values on the

Excel corrupts charts. How do I stop this?

After saving my work in an Excel 2007 file (that has multiple charts) and closing it, the chart formatting is corrupted and I have to resize all the fields every time I open up the file. How do I keep the chart from getting resize within the specified size of the chart?

Number and % on same chart

A+B= x I want to show: -In one stacked column, I want to show (A+B) and in the same chart in a line form I want to show how much percentage is B. How can I do this? Thanks!

Pivot table chart problem, How to show different subtotal levels

Hi, Using Excel 2003, I have a pivot table using external data via ODBC. I have a chart based on my pivot table. The table and chart are working correctly. The PTcontains two levels of sales subtotals 1st level is by county 2nd level is by state. My client is telling me that the data in the chart is too detailed. He wants to have the both levels of subtotals in the PT, but only the county subtotals in the chart. If I delete the county sales subtotals from the chart, they are also deleted from the PT. Is it possible for the chart to be based on the PT and not show

Changing ChartTypes will not change the color of the Series

I have Excel 2007 and trying to make this compatible with users that have Excel 2002/2003. I am having a hard time with the code below. When I change a specific series from a stacked chart to a line and then try to change the color, I am not successful. I am successful with changing the chart type, however. 'Create the Average Line .ActiveChart.PlotArea.Select .ActiveChart.SeriesCollection.NewSeries y = .ActiveChart.SeriesCollection.Count .ActiveChart.SeriesCollection(y).Values = "=Sheet2!R" & intRow + 1 & "C2:R" & intRow + 1 & "C" & rst.

Auto expanding X Axis for Chart

I have a chart setup, currently with reference to 31 cells width. The chart looks great if the user places a value in each of the 31 cells, however if there are only say 20 values placed across the cell row, the chart is displayed over to one side, with nil values displayed where no dat values were entered. Is there a way to have the chart automatically vary the width depending on the amount of values entered across the refernced row of cells? If there was only 20 values entered, then the chart would show 1-20 charted and leave out the 21-31. Corey....

I can get line chart to ignore zeros but the legend still contains

Hi, I have a table linked to a series of worksheets. The table shows products 1 to 6 in cells A2:A8. It then shows sales for each year in b2, c2. c3 etc. for product 1. b3, c3 etc for product two and so on. It is designed to show products sold in lots of different countries. I have a line chart linked to the table. It works fine if all six products are sold in the country. If they are not then because Product 1-6 is always entered even if not all products are sold the legend still shows them all. I have tried NA'ing the cells which stops them being charted but the lege

Secondary Axis - Alignment of Dollar Values

The dollar values for my secondary axis are left-aligned. I have tried various number/accounting formats but can't get them to right-align. There must be a way, right? Thanks in advance for your help.

How to do a pivot table with 2 different results

How to do a pivot table with 2 different line results

bars on chart do not match data points

Simple data set yet when I create a bar chart the bars do not match the actual values in the cells. For some reason, Excel produces a bar that is less than the actual value. Further, the same values in a cell produce different bar heights and although the data labels are the right number, the value is always listed as something less. How/why is it creating bars of a different value from the data point?

copy chart between multiple sheets in workbook

Hi, I have workbook with about 50 sheets. they have exactly the same table , just data(numbers in the table) are different. Also created a chart based on the table in the first worksheet. Chart is embedded in the sheet). I spend some time to format the chart and want to copy and paste it on the other sheets, but I want to reflect the data in each sheet. So each sheet has its own graph, which looks similar but reflects data on the sheet. Problem I am having is when I copy/paste it it paste absolute reference , so I have manually to fix data range :( and with that many sheets i

Change background / color of chart worksheet?

Need steps to change the color or backgound of the worksheet that is a chart. Have multiple tabs in workbook that are just the charts. Only option for background is to use Format-Sheet-Background. That changes background of chart, but not the grey areas around the chart on the chart tab.

Can i use a formula in the excel chart wizard?

I am creating a coursework in which i have to analyse a lot of data in the spreadsheet. it is already cluttered with columns and i dont want to add extra columns to add to the clutter. i was wondering whether there is a way to plot absolute values of a column without changing the actual values in the column or creating a new column using ABS() function. Thanx

How do I chart contours in Excel 2007?

I have some geophysical data I want to chart. How can I generate contours, or with the surface chart, how can I change the values for the coloured bands? Thank you

Pasting Pictures

I copy hundreds of excel charts into powerpoint presentations. I always use "paste as picture". I just got a new widescreen monitor. Now when I paste a chart from excel to powerpoint, the chart is wider and taller than to powerpoint slide. I have to shrink the image way down to fit on the slide by dragging the edges. Normally, this would be no big deal to do once or twice a day. But this is killing me to do it hundreds of times. Anybody solve this problem? thanks!

Chart Issue - Excel 2003

Hello, I have a chart that I need to build that uses a second category axis. I need to plot the following data in the following order: Actual Annual Premium Budget Annual Premium Actual Sales Budget Sales Actual Premium Collected Budget Premium Collected The actual and budget data is listed in 2 different tabs, with 12 columns - one for each month. The Primary axis is the monetary value; the secondary axis is the volume. I need to show the data in the order listed above but no matter what order I place the data into the chart, I can't get the bars to run in this order.

Chart formatting problems (multiple)

Using Excel 2007, and having problems with simple column graphs. The first half of my data points align properly with the gridlines along the Y axis, but halfway through, they move consistently to the right of the gridlines for the rest of the series. What's worse, no matter what column chart style I select, all I get is a bold vertical line with no shading or 3D appearance (it will pick up the color from the style I select). I've posted a .pdf showing what I'm talking about at www.caskstrengthmedia.com/ExcelHelp.pdf -- hope this may help explain my problem. Any suggestions

extra info is showing up in my secondary x axis, I can't get rid o

Excel 2003: I have a chart with a secondary axis the x axis is July 2009 - Jan 2010 but on the x axes at the top of the chart it's showing up as March 2009 - January 2010 I have gone to the source, made sure it's linked to the source, re-picked the source. what have I done wrong? Where is it getting March from? the new Y axis is behaving perfectly. When I look at the scale of the primary x axis, I notice it says the base is Months but that's not available for the secondary axis. Can anyone help? thanks, meenie

when inserting a chart excel is saying i cannot add any new fonts

When I attempt to insert a chart i am getting a message which says,"no new fonts may be added to this workbook". I am adding it to a billing process and I did the first 100 or so before it began this doing this, I am not adding any new fonts but I am getting this message, any suggestions on what is the cause so I can overcome it?

how do I create a transparent chart in Excel?

I have 2 graphs in excel (different data on different axis types) and want to put one over the other to find a good fit in the data.

how to create a stacked bar chart

Defect Code Part No. Defect Qty 206 A 2 221 B 1 221 C 1 221 D 1 I want to dreate a stacked bar graph to show that defct code had 3 defects total with part number B, C, D all contributing to the total, defect code 206 had a total of 2 wiht part number contributing 2.

Edit X Axis Range for Bond Pricing

I am trying to chart bond pricing and am having trouble getting an accurate graph. For example, bond pricing maxes out at 100.310 before resting back to 101.000 and counting back up. So when pricing goes from 100.310 to 101.000, it really is not much of a change, but the graph is overexagerated since it also accounts for 100.320 to 100.990 before resetting. Is there any way to correct this?

Formulae Help

Could anyone please tell me, I have developed a worksheet template were I have sourced the data labels in my chart. Sometimes this means 0 is inserted in the chart and I wondered if it was possible when I used the formulae below that I could state that if the source cell equalled 0 then this should not be used. =' Data'!$O$32 Many Thanks in anticipation.

X Y (Scatter) Chart EXCEL 2007

I am plotting times on both X and Y axis. Y axis is fine. Underlying data fills A 1 to C 7 only. Data in column B and C is formatted as Time 13:30:55. Y axis formats correctly as (from top to bottom):- 14:00:00 13:00:00 12:00:00 - and so on down to and including:- 06:00:00 I want exactly the same format on the X axis. To format X axis I take following actions:- - go to Format Axis pop up window - Number tab change this to Time 13:30:55 - Axis Options tab Minimum: Fixed 0.25 - Axis Options tab Maximum: Fixed 0.58333 (As soon as I do this all the

Graph does not copy with the tab

I am using Excel 2007 and have a graph on the same page as the data. I want to copy this tab into the same workbook and then tweak the data. I right click on the tab, check the copy box, and Ok. The problem I have is that the graph does not copy with the tab. I get all the data that was on the tab I copied from, but the graph object did not come with the tab. Why not? Is there a setting in excel to get the graph object to copy with the tab? Thanks, Dean

Positioning x axis at bottom of chart with negative values

Im using Office 2007 and have a simple line chart with negative values on the Y axis. I have ticked the 'values in reverse order' on the Y axis but the X axis flipped to the top of the chart. How can I keep it at the bottom please? Thank you

Problem with stacked column chart

I'm using Excel 2003. I have basically 2 sets of data, the 1st is a total count of people and the other set is a breakdown of the total count into 5 subcategories. I have a stacked column chart with a weekly category axis that has the 5 categories and the total all in one column per week. However, the count is off because it's adding the total and the 5 subcategories. I only want the series value to be the total. For example, if my total is 500 then it is showing 1000 for the series value because it's adding the total and the subcategories (subcategories always add up to the

Excel 2007 - VBA - set xaxis orientation

How can I set the xaxis to an arbitrary angle, say -70 deg using vba? I recorded a macro to do this and it does not actually do anything??? Tried it 3 times. I end up with the proper layout but the recorded macro does not actually format the xaxis when run again?! QB

half way though chart, lines between data points missing

I add data to the chart on a daily basis. All of the sudden it posts the data points, but the connecting line is missing. All OK since 1/1 until 3 days ago.

Chart not responding

I have just opened a spreadsheet that I use every month (saved as .xls but opened in Excel 2007) and then gone to the chart to update the data to show Feb's figures. But when I click with my mouse on the chart, nothing happens. It won't select anything. I tried doing a new chart but even that won't respond to my mouse. However, if I copy the data into a new spreadsheet and generate a chart, it responds just like it's meant to. What am I doing wrong in the existing spreadsheet?

Excel 2007 - Chart not working

First, I must say that Excel 2007 charting is much worse to use than 97, 2000 or 2003! It is not intuitive as it was with previous versions! I created a very simple line chart. The problem I am experiencing is that is start my initial value at 0%, which is fine and then promptly goes upto 100% and stays there for all the other points. What I love even more is that when I place my cursor over each point it actually give the proper values (73%, 61%,...) but always displays the line at 100%??? Anyone ever seen this problem before? Thank you for your assistance, QB

How can I add a chart on my user form ?

Hi, Would you please help me, I need to add a chart on my user name! Thanks in advance

Making Data and Axis Labels Different

Hi, I have a simple column chart that uses millions of units on its Y axis and puts a label above each column showing the exact value. At the moment the Y axis shos all the trailing zeros behind each million value, somethiong like: 40000000 36524102 35000000 x .. x .. x .. x 5000000 x colummns here What I would like to show is the Y axis values without the trailing zeros but the data label in full. I seem to be able to do one or the other but not

Showing a different set of data in a chart

I have a chart showing numbers between 50 & 250 for hours used, I also want to add in % complete but only show the data labels, I want the data labels above the columns for hours used, does anyone have any suggestions as to how to do this please. Thanks in advance Stuart H

sunflowers on a scattergram

how do you get sunflowers/petals for overlapping poitns on a scattergram?

How do I get 18 numbers to display in a column and not round out

I need a column to display 18 numbers and currently it is rounding the last three with zeros. I am using Microsoft 2003

multiple charts from a single pivot table

Hi can i create several pivot charts from a single pivot table?

Combining a 2-D column graph and a 2-D line graph on the same char

I would like to show a 2-D column graph and a 2-D line graph on the same chart. The independent variable on the X-axis (name of employee) is the same for both graphs. The dependent variables on the y-axis are different: (1) years of experience (column graph), (2) cumulative years of experience (line graph). I need to use two different scales for the y-axis to make both graphs visible, as the year of experience of the employees ranges between 1 and 40 years and the cumulative years of experience ranges between 1 and 1500 years. The input data for the graphs are listed in three co

Excel 2007 chart frustration

Hi, First time post, so be nice to me! I'm having a problem with Excel 2007 in that I cannot get it to format a chart the way I would like it. I'm sure the issue is a simple one for those in the know! This is what the chart looks like in Excel: http://img202.imageshack.us/i/excelaxispuzzle.jpg/ This is what I'd like it to look like: http://img689.imageshack.us/i/excelaxisgood.jpg/ The second (good) shot is done in Star Office Calc. My Uni have provided me with Star Office, but I'd like to use Excel as I've paid for it! Thanks Simon

Chart x axis problem

Hi I have the following problem I create a graph from the following table. This table at first time contains only one line data and every hour data increaments. The chart works ok except from the first time where the table contains only a single line data. And the problem is at x axis series the description writes only the time and not time, type and fail description. Here is my table with a single line data A B C D E F 1 A/A Time Type TRD TRD Descr %Fail 2 381 8:00 CORG 55 org to oper 10 m

Combine 2 Charts 2007 Excel

I have a line chart (looks like an S curve graph) with two rows of data below & this chart looks exactly like I want it to. Period % Complete Dec-04 7% Jan-05 9% Feb-05 10% Mar-05 12% Apr-05 14% May-05 19% Jun-05 22% Jul-05 23% Aug-05 24% Sep-05 26% Oct-05 28% Nov-05 32% Dec-05 36% Jan-06 40% Feb-06 45% Mar-06 50% Apr-06 55% May-06 59% Jun-06 63% Jul-06 66% Aug-06 71% Sep-06 75% Oct-06 78% Nov-06 81% Dec-06 85% Jan-07 87% Feb-07 89% Mar-07 91% Apr-07 93% May-07 94% Jun-07 94% Jul-07 95% Aug-07 95% Sep-07 95% Oct-07 95% Nov-07 95% Dec-07 95% Jan-08 95%

Cluster Stacked Chart with Difference Embedded

I'm using Excel 2003. I know how to create a cluster stacked chart, but now I want to add a difference. A example of my data is below. JAN FEB Screen Enroll Screen Enroll Site 1 5 2 7 3 Site 2 6 1 9 4 I want to stack for each site Screen and Enroll with the total being equal to Screen. So for instance, I want to have the JAN stack for Site 1 to be equal to 5 with 2 embedded within 5. I could set up my table to be: Screen = Screen - Enroll. But I want to

Excel 2007 chart titles

Good morning, I have just updated Excel 2007 to SP2 on my personal laptop and when I try to enter a chart title it will not allow me to enter a second line. When I hit enter nothing happens. My work computer has SP1 and it also will not advance to a new line when I hit return. I had to go back to Excel 2003 to enter the titles to get the lines I wanted. Any suggestions? Thanks, Diane

Pivot Chart Time Series work around?

i'm running with Excel 2002 sp2. I'm now aware that a time series x-axis is not available in a pivot chart. Maybe there's a way of getting pivot chart flexibility AND a time series x-axis by other methods?