Forum Discussion
I am trying to make a separate charts for each row on the same sheet.
I am having an issue with making the charts uniform. Row 1 is the Titles for the columns Row 2 - 5 is what I am looking to make separate charts for. Well this works well with Row 2, but whe...
That doesn't matter
I am not sure how it does not matter. You said right click on chart you copied. I am not able to copy the chart, so I can not copy it.
Perhaps i didn't catch. What i mean
- you select your chart, click Ctrl+C (or Copy in Ribbon)
- stay on any cell at this sheet or another one and paste the chart (Ctrl+V or Paste in Ribbon)
- right click on this new chart and click Select Data from menu
- in left part of the window select your series and click Edit
- select cell/range for series name/value
- Ok, Ok
I click on the chart. Click Ctrl+C but it does not copy the chart. It will not paste.
- Another way to copy a chart is to select it, then hold Ctrl while you drag it to a new location.
