Forum Discussion

Copper Contributor

Oct 19, 2017

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...

Charting

excel

JJ Eggers

Copper Contributor

Oct 19, 2017

The chart will not copy on the same sheet.

SergeiBaklan

MVP

Oct 19, 2017

That doesn't matter

JJ Eggers
Copper Contributor
Oct 19, 2017
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.
- SergeiBaklan
  MVP
  Oct 19, 2017
  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
  - JJ Eggers
    Copper Contributor
    Oct 19, 2017
    I click on the chart. Click Ctrl+C but it does not copy the chart. It will not paste.
JJ Eggers
Copper Contributor
Oct 19, 2017
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.