excel迷你图 vba_显示隐藏数据的Excel迷你图

excel迷你图 vba

Do you use the sparklines that were introduced in Excel 2010? Last week, I was building a dashboard, and wanted to show sparklines for expenses and revenue.

您是否使用Excel 2010中引入的迷你图？ 上周，我正在构建一个仪表板，并希望显示支出和收入的迷你图。

It didn't go smoothly at first, but I finally got things working, and then I ran into another hurdle! Here's what went wrong, and how I fixed things.

起初进展并不顺利，但是我终于使事情正常了，然后又遇到了另一个障碍！ 这是哪里出了问题，以及我如何解决问题。

创建迷你图组 (Create a Sparkline Group)

In this example, I had expenses and revenue in alternating columns, and I wanted expense sparklines in cells C4:C14. So, I selected those cells, and on the Ribbon's Insert tab, click the Line command in Sparklines.

在此示例中，我在交替列中有费用和收入，并且我希望在单元格C4：C14中有费用迷你图。 因此，我选择了这些单元格，然后在功能区的“插入”选项卡上，单击迷你图中的“线”命令。

In the Create Sparklines dialog box, I selected the first range of expense cells, then pressed the Ctrl key, and selected the other two ranges.

在“创建迷你图”对话框中，我选择了第一个费用单元格范围，然后按了Ctrl键，然后选择了其他两个范围。

When I clicked OK, an error message appeared -- "The reference for the location or data range is not valid."

当我单击“确定”时，出现一条错误消息-“位置或数据范围的引用无效。”