OMIS-Excel Notes-Linda's

Commonly used when working with long or wide

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Axis Choose Secondary Axis from the Format Data Series window Format Plot Area and Data Series 26 OMIS2000 Excel Notes Jessica Gahtan OMIS2000 To change the fill color or texture choose Fill and then, for example, choose picture to get the wood texture for the columns Format X- and Y- Axes The same technique applies. Right click on one of the axes and choose Format Axis 27 Excel Notes Jessica Gahtan OMIS2000 Add Data to the Chart Right click Choose Select Data Change the range in the chart data range window 28 Excel Notes Jessica Gahtan OMIS2000 Support Red Lion Pub 1. Open RedLionPub.xls 2. Create a Line Chart to compare the food and alcohol sales over the given two weeks. 3. Add a new column: amount of tips per day. Add the corresponding line to the graph. 4. Add a new column: tips as a % of total sales. Add the data series to the graph with a second vertical axis. Show how to change the fonts, scale, size, legend manually Updating a Chart • When you update the data in a spreadsheet, the chart will be updated automatically. • Try changing some data for the Red Lion Pub! GOOD DATA PRESENTATION Example - Bar Chart 45% 40% 35% Not Zero 30% 25% 20% Marshall Smith Jones Candidate Truncation • In this graph the vertical axis has been truncated which distorts the relative heights of the bars • This gives the impression that Marshall’s lead over Smith and Jones is greater...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern