Wednesday, December 19, 2018

Create an X Y Scatter Chart with Data Labels

How to create an X Y Scatter Chart with Data Label. There isn't a function to do it explicitly in Excel, but it can be done with a macro. The Microsoft Knowledge base article describes it. See the link to the article (along with the Macro code) at http://support.microsoft.com/kb/213750


Wednesday, December 12, 2018

Create a Header or Footer in Excel

How to create a header or footer for your excel document. You can provide information such as date printer, page numbers, or the file name in the header or footer areas when the file is printed out. Show two way to configure this.


Tuesday, December 11, 2018

Create a Bubble Chart

If you've create x y scatter charts, you'll probably like bubble charts. In addition to the horizontal and vertical series of data, you can add a third series of data which will show the difference between variable by varying the size (like the size of a circle or bubble). Check out the video to learn how to create a bubble chart and also using images or picture in the bubble instead of the colors.