Once the worksheet’s structure is in place, you can add a chart to represent the locations of your stores and depots. You can use an X-Y Scatter chart and represent the stores and depots as separate data series
- [Instructor] Once the worksheet structure is in place,…you can add a chart to represent the locations…of your stores and depots.…We'll use an xy scatter chart and represent…the stores and depots as separate data series,…so they appear in different colors in the chart.…My sample file is the location_03 workbook.…You can find that in the chapter three folder…of the exercise files collection.…For a brief review, we have two different entities…we're working with, the store and the depot.…
We have x and y coordinates for each.…The store coordinates are in columns B and C,…and the coordinates for the depots are in H and I.…To create the chart based on the store coordinates,…I'll select cells B one through C26.…I'll scroll back up, and then on the insert tab…of the ribbon, I will click the scatter…and bubble chart button, and then click the scatter chart…in the top-left corner.…
So there I have the plotted position of all of my stores,…and I'll just drag the chart over to the side.…Now I can add the depot coordinates.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Finding target values using Goal Seek
- Finding a solution using Solver
- Tuning investment portfolios
- Organizing worksheets
- Creating objective and control formulas
- Experimenting with different constraints
- Optimizing resource placement
- Defining decision trees