Hi, I a trying to plot a graph of the last 30 days (line graph is fine). Since everyday I keep adding data, how can I make excell pick up the last 30 days...

Hello, I created a line column chart on 2 axis. I have four data sets. The first 3 should go on the primary Y axis as columns and the 4th should go on the...

Is there any way to modify the Chart Tips (which work like ToolTips) in an Excel scatter plot? I can change text labels in a scatter plot with a short VBA...

I have a multiple line chart that uses both vertical axises where the range changes regularly for each series. I set both axises to the desired setting so...

I have prepared a large number of Excel templates that have charts I pre-defined for the user. Each of the user-defined charts I set up uses colors that are...

I have a stacked bar chart that shows monthly sales by customer type. I want to add an additional data series to show the monthly forecast, to be displayed as...

What is Solver's limits for constraints and adjustable cells? According to Microsoft Knowledge Base Article 75714 it is: 200 adjustable cells, and unlimited...

Is there other specialized software which would be an add-in to Excel and give me a larger variety of chart types?

Hi. I'm trying to make one chart that can displays ten data series, but one at a time. I have data for ten plants by month. I have made a chart that has the...

Is there a way to combine two sets of data with common X & Y axes on a scatter chart that lets the viewer see that there are two clusters of data (say with...

If I use the following formula: =IF(B25="","",B25+C25) in Column U all the way down to Row 20000 to create a new value... (Column B has a date and Column C...

I'm trying to crate a chart where to information in the cells can be typed on a slant

G'day all. I'm having difficulty with a chart resizing it's plot area when the chart type is altered. The user can click one of four buttons (2D, 3D, Line,...

I am making a chart using data from a worksheet that includes only weekday dates, however, when I make the chart using that source material, Excel...

"How do I change the format of a data series in a chart from a line to a column?"

I am attempting to link a cell from my spread sheet to a text box in my chart, but have been unable to do so. Does anyone know how or if this is possible.

Hi Steve, There is no dialog-box option to include/exclude a data series from the legend. That said you can remove a single legend entry. Select the legend...

Hi, I'm required to do "waterfall" diagrams on a nearly daily basis at work. My employer likes to show development in numbers this way. I'm not even sure if...

Hi, I have the following data set Apr May Jun Jul Aug Sep 2002/03 491 233 2039 2146 292 2716 2003/04 2523 2261 1054 784 2267 41 What i want to do is have...

Blewyn - You should make an XY Scatter chart, which plots according to the actual X values, not a Line chart, which plots according to the order of the...