Excel Tips


Avoid 3-D Chart Types »

July 5, 2023

I like the look of 3-D chart types, but they don’t seem to be accurate.


Use Meaningful Chart Titles »

July 4, 2023

Excel tends to add boring chart titles. A chart title such as Sales or Profit merely labels the data in the chart. The title is nothing more than a legend in a large font. How can I make my chart titles more meaningful?


Select Anything on a Chart to Format »

July 3, 2023

I need to further customize a chart. How do I format a series or a single data point?


Display an Axis in Millions »

June 28, 2023

My numbers are in millions. I am wasting a lot of space showing all of those zeros along the vertical axis.


Legend At the Top »

June 26, 2023

Excel always adds a legend on the right side of the chart. Visualization gurus say the legend should be at the top or left of the chart. You don’t even need a legend for a one-series chart.


Add New Data to a Chart »

June 22, 2023

I need to create 12 charts every month. It is a real pain to re-create these charts every month.


Teach Excel Your Favorite Chart »

June 21, 2023

I have to create line charts, legend at the top, with a title, scale in thousands.


Copy a Chart Detached from the Data »

June 21, 2023

I want to make a copy of the current chart, detached from the data. I have to chart 100 customers, and I want a quick way to move to the next customer, copy the chart, move to the next customer, copy the chart, and so on.


Move a Chart »

June 20, 2023

I created a chart and it is in the wrong place. How do I move it?