• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel help

K

krunchykrome

Lifer
I have raw data on an excel spreadsheet. I need to create a graph displaying 2005 sales, and as a benchmark, the 2004 sales. Both figures should be a single line in different colors.

Anyone know how to do this?
 
Highlight the data and click the chart icon (or go to Insert > Chart).

Follow the instructions. It's pretty straightforward.
 
If you need more precise instructions:
Highlight the data with 2005 sales - click Insert - Chart. Select Line Chart type - select Chart subtype: you need 'Line with markers displayed at each data value'.

Then next - Series tab - Enter Name field (for ex: 2005 Sales). Select Category X values, then click Add (series) - choose Series2 Name (for ex: 2004 Sales). Choose Values for this series by clicking on the small square to the right of the field, highlighting data with 2004 sales and clicking on the square again. Click Next.

Then you may play a little with various chart options, choose chart location and click finish.

That is all.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top