In previous versions of Excel I was able to copy a worksheet that contained a chart and have the links for the chart update to the new worksheet name. In Office 2007 I am not able to do this - my guess is there is a security setting that is not allowing the update to happen. Any ideas on how to change this??
2007-02-22 01:26:39 · 2 answers · asked by tholland_83 1 in Computers & Internet ➔ Software
Same functionality. Menus are located at different places. Nothing to do with security.
2007-02-22 02:58:26 · answer #1 · answered by unnga 6 · 0⤊ 0⤋
Hmm, it's the same way. If you want a vertical bar chart. Enter your data as usual. Rows represent the X axis and Columns represent Y axis in your vertical bar chart. Once the data is in, select your range, then select "insert," followed by the model of the chart. Finally, you can change the values of your axis by right clicking it on your chart. Hope it helps, good luck~
2016-05-23 22:48:45 · answer #2 · answered by Anonymous · 0⤊ 0⤋