Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

Excel charting problem

Hello Experts,

Having trouble redoing Chart 5 in the attached file. It should look similar to  Chart 4, but using data in rows 112:127.

Whatever happened to that chart wizard in the older versions of Excel?

Thanks!




ims-ee-tmp.xlsx
0
tomfolinsbee
Asked:
tomfolinsbee
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

click the chart, click Design on the Chart tools, then Select Data on that ribbon. Now you can click and edit each individual data series and set its source.

cheers, teylyn
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
At the end of that dialog box, you see a line with <blank series>. This points to data in row 148 and disrupts your chart. Delete the blank series and the chart is fine. See attached.

cheers, teylyn
Copy-of-ims-ee-tmp.xlsx
0
 
tomfolinsbeeAuthor Commented:
Thanks a lot!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now