charts 2003 vs 2007

I made a bar chart with 2 data axis in excel 2003. Some of employees have changed to excel 2007 and some in 2003. I have excel 2007 and when I send out the charts in an email, the 2007 users chart looks fine. The excel 2003 users have both axis labels on the same side. This is from the same sent email.

Making a Bubble Chart with 4 variables instead of 3

Bubble charts allow for 3 variable (x, y, and z). Is it possible to add a 4th dimension to Excel Bubble Charts (w, x, y, and z)? What I want to do is make a "pizza slice" in the bubble." For example if each bubble represents an entire US industry (furniture, electronics, etc...), then I want to make a slice in each bubble showing the size of a specific sub-section of the industry. For example, if the whole bubble is the electronics industry, then I want the slice to represent the percentage of the industry that is, let's say, Sears electronics sales. Is that possible? If no

Excel and Powerpoint Linka

Is it possibly to modify Powerpoint Links into an Excel Spreadsheet without doing it maunally each time. The steps I have tried have not worked correctly and the links are not updating. I need all the help I can get please. (Using Microsoft 7)

Is it possible to use image files instead of points in a X-Y chart?

Dear colleagues I work as product manager and frequently I have to prepare a X-Y chart comparing the prices of the competitors products. Instead of using a legend, I want show the pictures of the real products. Actually, once the chart is ready I have copy-paste every picture. Do you know if it is possible to do that automatically in Excel 2007 ? Thanks

In a Line-column graph on 2 axes, how do I stack the columns?

In a line-column gaph in Excel 2003, I need to stack 2 columns on the y axis, leaving the line on the right hand axis unchanged. can i do this in chart types, or can I set up my data table some way that this will happen automatically? Any advice would be appreciated. thanks

Excel 2007: X-axis labeling

Excel 2007 all MS updts I have a line chart of y-axis values and x-axis dates. The both axes get their data from the same Excel worksheet with the y-axis 'like temperatures'. That is, values vary (oscillate from + to - and - to + back (but not sinusoidal, just an oscillation back and forth around the y=0 line). The issue is that the x-axis is displayed (vertically) with ALL the dates overwriting each other for a 2 year period of time. All my data is daily M-F. Hence, for the y=0 line ALL the daily dates are bunched up. These dates then overlay the actual data. 1) I'

excel2003

histogram total in table but not in chart

Refresh Pivot Chart with Table?

I'm creating a large workbook with master data on one page and on all following pages Pivot Tables with associated Pivot Charts, one worksheet per state, 4 tables and charts per page. When I copy the Alabama formatted page to another worksheeet and change the Report Filter to Arkansas the table reflects the correct data, however the chart still shows Alabama data. Right-clicking on the chart and Select Data Source provides a greyed-out Chart Data Range. How do I fix this? Ideally I'd like to do this in as few steps as possible, but will change each chart individually if I must.

My charts do not show when moved as a separate chart tab...

In excel 2007 my charts are displayed when inserted in a a sheet but they do not show when moved as separate tabs

Full chart view?

When I have the verticle axis set to automatic on the Min & Max range it usually shows a huge distance on the chart because it generally defaults to 0. If the data is 55-100, the chart will start at 0 at the bottom and the 55-100 will be toward the top scrunching the data. Seems like it should size up the data to best fit everything when on the auto setting. I don't want to use a fixed setting because if the data changes then I run into a similar problem. Is there a way to either change the default settings so the charts will automatically size themselves, or something else I can

Interpreting Values

I work in a microbiology lab. We test if bugs are Susceptible, Intermediate or Resistant to a particular antibiotic. In order to make this determination we look at where a numeric value (we call this an MIC) falls in a set of pre determined interpretive criteria. I have on a simple chart the number of samples that obtained a particular MIC, it allows us to see the spread and if the number heading towards a value that would make them resistant is emerging. But my question is, can I on the chart show where the column of samples with a different interpretation to those that have gon

Excel 2007, Ribbon: 2 added Groups<?>

Hi, I saw the following: * Chart Tools > Layout > 2 added groups (not on mine, but on another PC): 1. Fills Group > Patterns & 2. PTS Tools Group > T Error Bars My Question: How did they get there and how do I added them to mine? (I was of the understanding that 2007 Ribbon could not be modified (maybe add an Add-In tab at best). THANKS! Gene:)

why won't excel allow me to add more data to a chart?

For some of my data I skip days for collecting it so I use the shift key to click on the days I do want in the chart. I have been doing this for awhile but now that I'm obtaining more points it has simply stopped letting me add data points. When I click on the one where it stops collecting it erases all of the others I have clicked and makes a stop noise. I need to add more data so why won't it let me??

Callouts in 2007

Hello, I have a VB6 app that launches Excel and generates charts. Currently we use Excel 2003 but the company is finally adopting 2007. Parts of the chart display as expected, but the callouts do not behave the same. The following code works fine in 2003, but doesn't work in 2007. (The sub is called AddLegend even though it should be AddCallout). There is also another code section where the callout is positioned and the Shape.Adjustments are made to adjust the callout line length etc.... The idea is that a chart could have multiple lines on an X-Y Scatter plot and a callout per

Show only specific Series in the data table

Any way to show series A - D in the graph and not on the data table and series E-H on the data table and not on the graph?

Excel 2007 default colors charts

How do I change the default chart colors in Excel 2007? Thanks, Gene

best timeline

Hi, What do you suppose is the best timeline template and/or add-in for Excel or Word 2007? It should extend into the past and fututre. Thanks much, Steve

excel 2007 11 x 17 chart printing problem

I can not get a chart to print on 11 x 17 using excel 2007. The printer just shows spooling.

Plot area changed after reopen document

Hy, I have problem with unstable format of charts in an Excel 2007 spreadsheet (under Windows XP). When I re-open a spreadsheet, the plot area is usually contracted to a much smaller portion of the total chart area, leaving lots of white space around the edges. This happens repeatedly with some, but not all, of the charts in my spreadsheet. Some are x-y plots, some are combination line, bar plots. Is there any way to keep the size of the plot area from changing? Thank you for help.

Pivot Table-Change Data Source? Excel 2007

I need to update a series of pivot tables by adding 2010 data. What's the best way to do so? Add the updated info to the source document and refresh, or create a new data source and refresh all the tables? Does the new source have to have the columns in the same order as the previous? If I create a new source document, how do I tell the tables to change the source? Other responses to this question say to rightclick a cell and use the wizard. I'm using Excel2007 and right clicking doesn't produce a wizard. Thanks

Plot value at top of chart

Is it possible to have the highest data point on a line graph plot at the very top of a chart? For example, if the highest data point is 90 then I would like highest value of the y axis to also be 90 placing the data point at the top of the chart instead of excel automatically adding a "cushion (like 10) to the y axis. The data points vary each time the chart is created so i can't fix the value at 90. Thanks, Joe M.

Excel 2007 - problems with macro to change series formula

Please help! I've just been moved to Excel 2007 and now find that the wonderful macro below no longer works (the single chart version is still OK). I have files with 50 charts on a single worksheet (the data is on a separate tab) and I need to choose which rows to include rather than having an auto update. The files are accessed from multiple workstations so a macro saved in the workbook was ideal. Is there any way I can modify this code to get it working? Thanks in advance. Sub ChangeSeriesFormulaAllCharts() ''' Do all charts in sheet Dim oChart As ChartObject

Get 2007 Chart to fill page

How do I get Excel 2007 to print a Chart "Full Page?" In previous versions, you would just click on the chart and hit "Print" and excel would automatically stretch the chart horizontally and vertically to fill the entire page. In 2007, my chart fills between the left and right margins, but there are several inches between both the top and bottom of the page and my chart. (Even though the page margins for top and bottom are set as low as they can go.) What am I missing? Thanks.

Chart with differing x axis

I want to make a chart that has data from dis-similar x axis. For example, I want to have a line graph for an x axis with a range of 50-100. On the same chart, I want a line graph with an x axis that has a range of 90% to 110%. How do I do this?

Template for Hours+ Commission

looking for Template for Hours+ Commission in excel 2003