Click the chart. Click the Design tab. Click the Select Data button on the Design tab under Chart Tools.
|
|
![Click the chart. Click the Design tab. Click the Select Data button on the Design tab under Chart Tools.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vFvNTh9mOuV42cILKS3lWl1FCdnXzrCF01Mst7eo-nLBVxgIkuBoCbUZm9ccteMBVy_OI4ap1OS56kP-HPqMBCG4L8JztTSUBinj2gA1lw-vSyrdYNU4Qid90Sv5qgqgRfsaOLQSQXWRWqXpvn5tw3jhZITV64x0xOL4oCKmatC26NJLKyYd3LZ-5EqoSkOp6B_TX_6pdH7xR9NVXYcw=s0-d) |
Click the Collapse Dialog button to minimize the dialog, so you can select a range in the worksheet.
|
|
![Click the Collapse Dialog button to minimize the dialog, so you can select a range in the worksheet.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_tsaL2OpWb9WukvWyzD0JtlaoNKRqERdMj5FXw8kD7r5bsZwaNz-2O3t7cIkcJAwV8rVrJyzztpCZMb9bYJAxU_RBQFUcN32IMbhvLo6fmiCVgR4yCm6TeQlHNaIA6M7RzYQD1KBoOxmkkZWkkrz9cZtUtZbKGxUjthtiIspcgw2a38Yu5A6BU8R_JZ_DHZzkiNHDSy_1lE7_pSjLGE=s0-d) |
Click the Expand Dialog button to maximize it again.
|
|
![Click the Expand Dialog button to maximize it again.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vsH7aV6qk7HQU5kVfU85QP7iHaRtS6oqk74lMiTrehUPVbN2zop4S7Jit47fx9zwphA-INpkxcehxwt25B5LhzHcpLiUoHXhkZ-L2KWva1xwli7hMKR6Rbg0JLxe5-wqB7WAMx5YK3-DOV33F7icYdwQvp2Df_vdCyuXv0d5R8bEiOWpD689w_tAYIsWtK4gGr-s5bQhPJ4lMIh9muag=s0-d) |
Chart data range. Displays the data range in the worksheet of the plotted chart.
|
|
![Chart data range. Displays the data range in the worksheet of the plotted chart.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_s0oR7GyyfVZ-wUArqVRakN3FJENNmKxem2UBXyoMpbxSzYAM4FbpRqSyc9tCxbVkgOUTfmDtash4jQOI05n5ouJMgrkaA6M-nvl45aqWKkYPnEYbDVFhPhPq65gM4gevEkhUDBLBIMFiSbMhIyBWNapxmbfGu3vC-1inG3Ub2c7R1uakT4w4_-PGGhZ6MzvJQlVpOoUyFs7n_eTojzYQ=s0-d) |
Switch Row/Column. Click to switch plotting the data series in the
chart from rows or columns.
|
|
![Switch Row/Column. Click to switch plotting the data series in the chart from rows or columns.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vC8us5s0zXM4yrfbVj722ZbeLNQwT4S2Bh9zHfkEghBz4BDsBs6deZKLY3vCxJiHqKTzAottjlr_1J7-ahbbQJJvgdHbJAbWY1QNHbQWNV94rRig2X3VnIHIhqpaLUjgcBszZcwEzGh4X-24AseRzy6EcuG7R0sMdnHYhQglfSfMi3OxyhWhvKKFP-6ngNZt5-UKSmdb2UF1i9Qe-7=s0-d) |
Click Add to add a new Legend data series to the chart.
|
|
![Click Add to add a new Legend data series to the chart.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vEA9EztrIjgxK5P9EP6E5qONYJc72PY6WCh9bJLKriDx8ZWoN_H157bZvGi1wq6ORNLFP1DfwLV4m5rquUyKJ08UZsAWjrOIW7JNSiAyr7R8XAzcFAz76C3WioqoO4FHLyalUnHzUL_ldlgvox5hFI5z0dO5WUl2C0XjtMGgk6XXU64OfqZaShvnLO_DLPN56v3ZIF1TB2wOJ6VPmc=s0-d) |
Click Edit to make changes to a Legend or Horizontal series.
|
|
![Click Edit to make changes to a Legend or Horizontal series.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_t10jpu3-knnmkBr0iYoZXaUX8UnF_QFgesZnP3ksDkp4_e7tHuTOuH4G0hDOydRbOa8mbsuanInnGJi0rTghQiQJ666GcROLjuC9PJU4jaMjYAfNbar_kNGSaAABsTcV5bcPUb_-jfTXmZVBQWHjn3IQ961huHcXKhVNum5Ypt1s9WljfjK93aoYnfm30KNv9N8q-CER-5JUUTLLS8yg=s0-d) |
Click Remove to remove the selected Legend data series.
|
|
![Click Remove to remove the selected Legend data series.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uAK27pcTzUkco56zeHcJaTZKmyv4oz0XDNDO8Fo1QoI3CcQGNSvCdEPtrWa4Tt37DaKYHKE1D2C5V1GKMJgeDH61Yq5W4yKDufTOxDkt7JVG3pv4y9RegVzeaArUKj-Jw_osRDUxK9dypQUUarh61nTmYSP4w36Z_8h2X3cCyZSrS_DUuQ3ZI-YVhDcU0N_Xseuh1huwUHRKGUVmxV=s0-d) |
Click Move Up and Move Down to move a Legend data
series up or down in the list.
|
|
![Click Move Up and Move Down to move a Legend data series up or down in the list.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_tnZTLMcU0paNhr2Na8_9oV2fVxHL2bwFp-efzwXUGH9Z7P2jUNA91RnylIUCCQW1fkPcM3pkwiaImkf-O_YA9F5K5G0TZWpxjworCHr-hSfcR1MwhCGEQchwj9yM_lkUS_JuRa0WpK3v6qxJy5le7JDbLMm0gXoBwlTrdZZ0TUS8i7anrBj5WSKYQny-g6C4d_-yrgcX0vOm8DOXSkhw=s0-d) |
Click Hidden and Empty Cells to plot hidden worksheet
data in the chart and determine what to do with empty cells.
|
|
![Click Hidden and Empty Cells to plot hidden worksheet data in the chart and determine what to do with empty cells.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_v4PqvudcGkoougVYS6bMWobdIsQoMM1TpzCPp7qn9AVv3FaM0ph4mX8oRx88v-eXP7azJqBvKZerhsqvV7nttRWzfLhoPzoVgWuBe0qoEG7tBO1JygEPACEKEYKbWLZkGmuINjl9_KhRV7GQqtVUuBF0NWhGfxr5A-qSfc1raYnQSRdOv-vgOrCbSiCrh9Ahmumrcki6icNxyOeX9R2A=s0-d) |
|
![Click OK.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_sE8q-sb5nhkX-32_l2tOaoSPbqRSDH-x3oS37TP2qIGF44kBjLZa5z2jBDQs8HMxKrFHh1dTEN-XpReN9X0BD2d4ns7f8PfQfOcjBc13ZzZoFO7TNrMwby4BAwsKaKtMyuY9IfZCSS_SAmf6WT-YbzCq_emhsjfBGGPXWgJwkfkAQC=s0-d) |
No comments:
Post a Comment