Charts and Charting | Forum profile

Hmmm, nothing comes to mind. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ DPingger wrote: Thanks for responding, Jon. Yes it is a line chart, i should have said that earlier, and it's still grayed out. That's why I'm perflexed. Is there another setting someplace that I should check? TIA dPingger "Jon Peltier" wrote: If your chart is a column chart or a combo chart that...

Hi, Set the Area to None. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "CrownEquip-Jen" wrote in message news

Hmm. You might want to take a look at dynamic charting techniques to help limit the amount of data going into your chart. http://peltiertech.com/Excel/Charts/Dynamics.html It appears you are trying not only keep the data from months that have no data from being plotted, but also keep those months from appearing on the axis, correct? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "C...

I thought it was 97 "Richard" wrote: An earlier version of Excel had a world mapping module? Does anyone remember which version?

Add horizontal line to chart http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm http://www.processtrends.com/pg_char...ontal_line.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "John" wrote in message ... I am trying to create a single bar with a gradient from Red...

To get a chart with no data at all, select an empty cell that also has no adjacent cells that contain data. To get a chart with a limited subset, select the cells you want in the chart before creating the chart. On Thu, 12 Nov 2009 14:54:01 -0800, Huang wrote: When using the insert chart buttons, specifically XY scatter, Excel automatically plots my entire dataset. I do not want this to happen with large datasets b/c I need to manually delete...

Check to make sure the line chart is not the Stacked Line sub type. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "DPingger" wrote in message ... Thanks for responding, Jon. Yes it is a line chart, i should have said that earlier, and it's still grayed out. That's why I'm perflexed. Is there another setting someplace that I should check? TIA dPingger "Jon Peltier"...

An update. I've experimented with a small dataset and the problem is that when it appears you are formatting a whole series of data it formats only one number. The "handles" that appear to indicate what is being formatted are misleading. Only when you format the final number do the zeros disappear. That raises the question: "how do you capture all the data labels at once". "hans L"...

Andy -- I figured out the problem but now have another -- I have a trend line in the chart and I'd like it to stop where my data does, but it's going to whole length of the work days -- any way to fix this? thanks. "terri" wrote: Andy -- I using an if with an NA -- so for the days I don't have data it's giving me an N/A -- so for example if it's the 5th -- and the data for the 6th will be is cell A6...

Thanks for responding, Jon. Yes it is a line chart, i should have said that earlier, and it's still grayed out. That's why I'm perflexed. Is there another setting someplace that I should check? TIA dPingger "Jon Peltier" wrote: If your chart is a column chart or a combo chart that includes a column series, the setting may be disabled. Start with a line chart, change the setting, then convert the series to the...