Excel plot presentation

[MODELXLS]

I am using XY-style graphs for scientific computing, with many plotted curves on a single graph. I have two questions:
1) Is there a way of selecting specific values for logarithmic axis labelling? For instance, Excel labels at 1 and 10 by default. Can I have labels at 1, 2, 5, and 10?
2) Is there a way of selecting legends for specific curves, instead of for all, which is Excel default?
Any help would be appreciated.

 

[Jon Peltier]

A log axis only shows labels on the decades, starting with the axis minimum, so 1, 10, 100. You can always add a dummy series to a chart and add your own labels, as illustrated in this blog post: Custom Axis Labels and Gridlines in an Excel Chart.

You can delete unwanted legend entry labels by clicking once on the legend, then clicking on the unwanted legend entry, then pressing the Delete key. To get back a missing legend entry, you have to delete the legend and add it back.

 

[MODELXLS]

Thank you, Jon very much. It is very clever to use data labels for axes labels and gridlines. Is there a similar trick to insert shaded or colored shapes into an Excel plot?

 

[Jon Peltier]

You can fill some regions in a chart using Fill Under or Between Series in an Excel XY Chart.

 

[MODELXLS]

You can fill some regions in a chart using Fill Under or Between Series in an Excel XY Chart.

Thank you very much Jon. The combo XY/area plot works very well for my purpose. I am writing a manuscript and am planning on giving you an acknowledgement, unless you object - then let me know. Also, have purchased your utility.

 

[Jon Peltier]

Thank you very much Jon. The combo XY/area plot works very well for my purpose. I am writing a manuscript and am planning on giving you an acknowledgement, unless you object - then let me know. Also, have purchased your utility.

Great, thanks.