#1
|
|||
|
|||
How to make scatter plot chart of data with labels in horizontal axis?
How to make scatter plot chart of data with labels in horizontal axis?
I have Two columns of data in my excel file, which one of is in text format(see the excel attachment column A and column B.) I want to have a scatter plot of this data without restructuring it. (a chart like “chart b”). Can you guide me on this issue? I have searched the internet for this issue, but the way I found (making a stacked line chart and removing its line and ending up with a chart like chart B) don’t meet my expectation. ( I want to have a chart the data that have the same" X Axis value", lie above each other vertically.) |
#2
|
||||
|
||||
Quite difficult to set up, but a lot easier then setting up multiple series and you need do nothing to add new values except add/remove/change the table. You only need to change columns A and B, columns C and D calculate for themselves and the table adjusts its own size, and the plot changes automatically too adding/removing categories as needed.
There are 2 series: 1. For your data 2. For labels (a single point for each x value (category) at 0 y, with only data labels showing) Both series are true x-y scatter plots, not line charts. |
#3
|
|||
|
|||
Thank you very much. Your reply solved the problem.
|
Tags |
scatter plot chart |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to move horizontal axis labels on bar graph | gib65 | Excel | 2 | 10-31-2017 08:49 PM |
Scatter Plot X Axis Naming Convention | constructionjasont | Excel | 1 | 09-13-2017 02:49 AM |
my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. | jalea148 | Excel | 3 | 01-06-2017 09:04 AM |
Select which labels to display on horizontal axis on line chart | Jack H | Excel | 5 | 01-13-2016 10:05 AM |
Scatter plot with only second y axis | hanvyj | Excel | 0 | 07-26-2012 03:25 AM |