Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to create chart basic
How to create a scatter chart with spread sheet below. The x axis may be location and Y axis are lot name Lot value location A 3 1 A 4 2 A 5 3 B 6 1 B 4 2 B 2 3 C 5 1 C 6 2 C 8 3 D 4 1 D 9 2 D 5 3 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to create chart basic
Daniel,
Highlight the whole chart of data. Select the Chart Wizard on the top of Excel screen. Select the scatter plot. Data should be "rows" not "columns". Select the "Series" tab. "Name:" ="A" "X Values:" =Sheet1!$B$2:$B$4 "Y Values:" =Sheet1!$C$2:$C$4 This assumes that your data is in column A thru C, Lot in A1, value in B1, Location in C1. A's,B's, C's and D's in column A2 thru A13, so on and so forth. This will plot the data points, one color for A, another for B....... Good luck,hth :-) "Daniel" wrote: How to create a scatter chart with spread sheet below. The x axis may be location and Y axis are lot name Lot value location A 3 1 A 4 2 A 5 3 B 6 1 B 4 2 B 2 3 C 5 1 C 6 2 C 8 3 D 4 1 D 9 2 D 5 3 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to create chart basic
It makes no sense to use Lot as Y values. Looks like Location makes a good X
value, value a good Y value, and Lot makes a good series name. At least it makes sense given the small description you've provided. First set up the data properly. Put X in the first column, and each series' Y into subsequent columns, like this: A B C D 1 3 6 5 4 2 4 4 6 9 3 5 2 8 5 The top left cell of this table is blank. Select the table, including the Lot names and location numbers, and create an XY chart or a line chart. Format as desired. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Daniel" wrote in message ... How to create a scatter chart with spread sheet below. The x axis may be location and Y axis are lot name Lot value location A 3 1 A 4 2 A 5 3 B 6 1 B 4 2 B 2 3 C 5 1 C 6 2 C 8 3 D 4 1 D 9 2 D 5 3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic Chart | Charts and Charting in Excel | |||
create line chart with two axises in Pivot Chart | Charts and Charting in Excel | |||
Chart data file lost - need to re-create from chart? | Charts and Charting in Excel | |||
Create and Use Button Menu using visual Basic in Excel | Excel Discussion (Misc queries) | |||
basic pie chart question | Charts and Charting in Excel |