Hi, How do I make a chart such that if I have some zero values then those dont get plotted (especially in case of Line charts). Rather if I have values Oct...

The legend in my chart has about 8 items and I cannot get them to split into two columns. The legend is subsequently very tall and has to go at the bottom of...

Good day! In beta 2, charts are drawn incorrectly when embedded in right-to-left sheets (when the A column is displayed on the right side, for example...

Hi, Is it possible to use a Pivot Chart with a Pivot Table as the data source and select only part of the table to be charted. For instance i have 5 variables...

Hello, i am having a little problem creating a Pivot table for my poker league. Basically, there is a 15 week season, with different players playing each week...

I have 1400 names in a list each, person has their own data. I created a pivot pie chart to display that data. Can anyone tell me how to print the pivot table...

I recently discovered a curious "feature" of Excel. If you create a pie chart, and label the slices of the pie with data labels that include the percentage,...

Are there any vba functions to change the data displayed in the data area of the chart and/or legend text through VBA (ie not using the wizard, instead need to...

I've noticed an extremely frustrating, not to mention misleading, aspect of Excel 2K. If you have a column chart with a series whose values are...

I have office 2003. I am using xy scatter plot with sub type data points connected by smoothed lines. My problem is the point that should be the highest in...

I'm an excel chart beginner. How do I add data to the data worksheet to automatically update the linked chart, when the new data goes outside the chart range....

Ecxel 2003 I'd like to set a transparent level as a limit in a 3d bar chart. It needs to be transparent so I can see values less than and allow values greater...

I have created worksheets which utilize "offset" functionality, so that on a weekly basis I only have to change a single value and multiple tables I have set...

I have a list of data items which I want to put into a Pie Chart. Included in this list are a number of statistics that are under $5,000 so it makes the chart...

Hello Everyone.. I have a dashboard workbook which works fine in Excel 2000.. The Dashboard has lists which control the data which is being fed into...

Can you create links from part of a graph in excel to drill down? For example, in Adobe, you can set up a link so that a given bar when touched triggers a...

I have a HP designjet 110 nr plotter. I've created a plot that we need to show drilling activity. My first plot was 24"x36". Plot works great and to scale. My...

hi there! Thanks for this great forum and all you valuable contributors too! lovely job. I have some notepad files that contain data for me to plot. But...

Macros have been setup within excel so l can dump data into it and all the graphs update. There are colors assigned to certain categories however when you dump...

I am creating surface charts, and would like the colours to go in a logical order (e.g. fading from blue to red - or even just black to white) so that they are...