Charts

plot highlight
Is there a way of highlighting a trace so it stands out in a xy scatter chart of multiple traces? ... 14 Feb 2010 09:34

Random non-duplicating numbers
I know there is a lot of Q&A on this subject online but I haven't got any to work on my Excel 2003. I need to create random integers (up to 160,000) that do not duplicate. Actually it would be even better to have something that randomly chooses (non-duplicating) cells from another worksheet (ex. choose random... 13 Feb 2010 02:49

Set highlighted numbers in a graph
I am making a graph; I have number coming in from 500 to 3000 in the bar graph. I want to highlight horizontally 1200 to 2400 so when the numbers go in people can easily see if they only got 1050 they did not get within target. Can anyone help me ... 12 Feb 2010 23:34

consolidate charts from multiple pivot tables
Dear all, I have 3 different pivot charts based on three different pivot tables. I would like to consolidate these three charts in one. I have already tried to move all the charts on one sheet and remove the fill of the graph so I can visualize the three data series (in transparency) but adapting the format axis... 12 Feb 2010 10:04

Need help with showing Totals
I have a clustered cylinder chart. Along the x-axis, I have the average test score per exam per class. For example, in the first cluster I have the average test score for five exams in the Science class. In the second cluster, I have the average test score for five exams in the Mathematics class, etc. For... 23 Feb 2010 15:53

How to change document from a Chart to spreadsheet
Hello, I had a spreadsheet set up in Excel - somehow it has concerted the document into a Chart and I need to change it back to a spreadsheet please.?? ... 12 Feb 2010 08:56

How do I plot AVEDEV?
How do I plot Mean Average Deviation -the AVEDEV funcation - as opposed to standard deviation? Any suggestions? Thanks, Graeme ... 11 Feb 2010 15:05

xlStockVOHLC chart with extra xlColumnClustered series
hi all, I have ActiveChart.ChartType = xlStockVOHLC I'm trying to add to him additional bar: ActiveChart.SeriesCollection(6).ChartType = xlColumnClustered and getting error "Some Charts types cannot be combined with other chart types". this worked for me in Office2003. Is it possible there is no backward compu... 11 Feb 2010 05:02

drawing shapes move when printing
I use spreadsheets to solve complex structural engineering problems and so I need to draw shapes and lines to show what I am doing. When I go to print the worksheet the lines I have drawn shift on me and mess up the entire worksheet. Is there a way to shift all the lines to where they were originally drawn. Is... 11 Feb 2010 00:41

How can my colleagues modify my charts?
I write my analysis programs in Java. I like java except for graphs of analysis results and raw time series data. I have used the unmodifiable BufferedImage dot-matrix plots with fair results. But I want to draw graphics that my colleagues can touch-up or modify, because I can't predict everything they will want... 10 Feb 2010 19:07