User FAQs

If you have a question, please send it to us.

1) What is the quickest way to create a chart ?
(F11) - highlighting the source data and pressing F11 will insert a chart sheet (not an embedded chart) defaulting to a column chart.

2) Can you give the name of any new built-in chart types that were introduced in Excel 2016 ?
Box Whisker, Histogram, Pareto, Sunburst, Treemap, Waterfall

3) Can you give the name of any new built-in chart types that were introduced in Excel 2019 ?
Funnel

4) What are the different ways you can try and find charts on a worksheet
Paste Special > Objects
Find & Select - Selection Pane
Select Objects

5) Is it possible to set the whole chart range to be a named range ?
No. It will accept the named range, but it will be automatically converted to its hard coded values.
It is only possible to use a named range for an individual series.

6) Can I add shapes to my charts ?
Yes. To add a shape you must first select the chart, so it displays a black border.

7) Can I add pictures and graphics ?
Yes. Pictures can be added using the Fill Effects dialog box. Data series, patterns tab

8) Can I add dynamic axis titles ?
Yes

9) How can I highlight the maximum and minimum values ?

10) How can I rename a chart ?
Display the Selection task pane and rename there
Using the name box is random - investigate

11) How can I control whether blanks are displayed as zero ?
Select Data Source dialog. Hidden and Empty Cells. "show empty cells as"

12) How can I add a Horizontal Line ?
SERIES("Additional line", {0,1},{50,50},2)

13) What is the difference between ?

.SeriesCollection(1) 
.FullSeriesCollection(1)