How do I? I was asked to create a scatter graph of # of transactions in a year under discount bucket categories and then a second access that shows the cumulative $$'s associated with those. I have 5 categories for the discounts: <0% 0-5% 6-10% 11-15% 15% Can anyone help me? -- Thank you in advance!!!! ... 6 Jun 2010 10:31
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. ... 4 Jun 2010 14:47
Chart Data to a US map IS there a way to chart data to a US map? I want a visual of the US map with number of clients shown in each state. ... 4 Jun 2010 10:21
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 ... 4 Jun 2010 02:43
How do I insert a hyperlink into a chart element? How can I insert a hyperlink into a bar of a bar chart, for instance? I read on MSFT's help page that, "You can also insert hyperlinks in specific chart elements.", but I cannot figure out how to do so. ... 5 Jun 2010 15:50
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) ... 3 Jun 2010 15:40
Column Chart Conditional Formatting I have a column chart that compares 2 y values against a common x value. I want to compare the second y value to the first, if it is greater then make that bar green, if less then red, if same grey. Any ideas on how to go about this? Thanks Adam Bush ... 2 Jun 2010 16:30
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... 1 Jun 2010 10:52
Stacked column in 3D I have 9 data rows and 3 columns representing the dates. I insert a stacked column in 3D, it gives default min to max dates. But when I fix the vertical column values to my dates (which ranges 40296 - 40320 with 2.0 major unit) it does not show stacking of 3rd column. I also change the data to dates and cell for... 1 Jun 2010 01:08
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 ... 31 May 2010 09:46
Updating from 2003 to 2007: axis labels overwriting Hi We have some Excellbooks wih 200-300 plots. These were looking allright in Excell 2003, but in Excell 2007 the labels on the y-axis on many of the plots, have become so "tight", that they are overwriting each other, and impossible to read. It is possibe to go through each plot and change the settings for the ... 31 May 2010 01:10
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 lin... 30 May 2010 10:02 |