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

SergeiBaklan

Diamond Contributor

Oct 19, 2017

Hi,

Right click on the chart you copied, Select Data and edit the Series

JJ Eggers

Copper Contributor

Oct 19, 2017

The chart will not copy on the same sheet.

SergeiBaklan
Diamond Contributor
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
    Diamond Contributor
    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 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.