I had created a program in Visual Basic that Excel macros. One of the facilities was to embed a plot (Excel chart) in my application. To do it, the code...

I have 9,000+ data points that need to be in an X Y Scatter Chart. About 50% only have an X Value, but the absence of the Y Factor is important data. It...

I have created a bar graph with 5 bars. One of the data points has a disproportionately high value, and it is hard to view the other data points in the...

I'm trying to take our personnel spreadsheet and chart employee arrival and departure data so that we can graphically see where the gaps are and whether or...

I have many Line-type charts, all of which have as the X axis, the DATE. When I right click on the "X" axis, I get 2 distinctly different type options under...

I have a chart that is tracking sales for the month, (by day) the chart has Zero values due to an "IF" statment that has a false or the reference cell is not...

Hi, I currently have a number of graphs (10-12) that I need to replicate (for different data obviously) across 14 worksheets (approx 140-150 graphs in...

Is it possible to create a Chart using code? If so, how do I do that. Thanks

The maximum number of total data points in a plot is 256,000. However, I have setup plots with 1.5 million data points. Excel does not complain about...

I have captured a macro when I made the cutom changes to my pivot chart. I would like to run it automatically when the user changes the data point. I mean my...

Hi, Any idea how I would create a chart that always looks at the last 12 weeks data in a table that gets added to each week Many Thanks DC

I need to make a column chart that plots the average of a column of data, with error bars matched to the data (i.e. data series 284, 295, 214, 212 should...

Hi, using Office 2007 I have created 6 graphs (for 6 different KPI:s) in an Excel file. The graphs can be simultaneously updated by selecting a (Geography)...

Hello, I created a simple series consisting of two columns. Column A contains the numbers 1, 2, 3, etc. through 50 Column B contains the formula =log(A2),...

I have a chart in excel 2007 I want to sort rows 1-5 decending and rows 6-11 decending but when I select just that much and click to sort it re-hilights all of...

Hello, (Excel 2007) I created a graph and a linear trendline, showing the equation: y = mx+b B determines the starting point. How can I get the value of...

I have the following data that I am trying to get into a chart and it is not working. Ideally, I would like the height of the jumps going up the left side...

Hello - I have tried to find a solution to this (without using an add-in), but have been unable. Suppose we have values like this: Time Rating...

We have just migrated to the 07 version with 'ribbons' etc. and I have saved my spreadsheets to the new version. The scroll bars (horizontally & vertically)...

I must say , working with the component is pretty much a nightmare and waste of time, as the structure is convoluted, different than Excel, and there's no ...